turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- Base SAS Programming
- /
- What would be the procedure similar to making a ex...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

03-06-2017 02:06 PM

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

I need 2 examples onesSummarizing and other counting

Accepted Solutions

Solution

03-06-2017
04:15 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Angel_Saenz

03-06-2017 02:24 PM

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

All Replies

Solution

03-06-2017
04:15 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Angel_Saenz

03-06-2017 02:24 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Angel_Saenz

03-06-2017 02:50 PM

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=

Art, CEO, AnalystFinder.com