As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.
Here are some tips for How to share your SAS knowledge with your professional network.
Pivot table, creating
One method of creating an Excel PivotTable in SAS is explained by Ted Conway in his SUGI paper "Sur La Table: Creating Microsoft Excel PivotTables in a Jiffy from SAS® Data". It is available here on SAS.com.