What would be the procedure similar to making a excel pivot table?

[Angel_Saenz]

What would be the procedure similar to making a excel pivot table?

I need 2 examples onesSummarizing and other counting

[Reeza · Accepted solution]

It depends. There are many different ways starting from:

• Proc Means, Summary, Univariate
• Proc Report
• Proc Tabulate
• Proc Freq
• SurveyFreq or SurveyMeans 

All of these Procs have examples in the documentation. 

I would probably start with Proc Tabulate as it's pretty versatile. 

Here's a paper with examples

http://www.lexjansen.com/scsug/2007/how/HOW-Winn.pdf

[art297]

On the other hand, if you're on a system that can run VB Script (e.g., any version of Windows) you can use SAS to create an Excel pivot table for you. For some sample code, take a look at: https://listserv.uga.edu/cgi-bin/wa?A2=ind0506a&L=SAS-L&O=D&F=P&X=FB41D225061C8C7F9B&P=62191

Art, CEO, AnalystFinder.com