Transposing Proc Tabulate

Accepted Solution Solved
Reply
Super Contributor
Posts: 497
Accepted Solution

Transposing Proc Tabulate

[ Edited ]

Is there a way to show a single column list of values as a column rather than a row with proc tabulate?  E.g.

Column name

A 5

B 15

C 30

All 50

 

Instead of Column name A B C All

5 15 30 50


Accepted Solutions
Solution
‎10-03-2016 10:35 AM
Super Contributor
Posts: 497

Re: Transposing Proc Tabulate

Found the answer.  My question was rather bad.

 

table (application_type = ' ' all), N = ' ';

View solution in original post


All Replies
Super User
Posts: 19,785

Re: Transposing Proc Tabulate

Posted in reply to DavidPhillips2

Not sure I follow. Can you show a more detailed example? 

Solution
‎10-03-2016 10:35 AM
Super Contributor
Posts: 497

Re: Transposing Proc Tabulate

Found the answer.  My question was rather bad.

 

table (application_type = ' ' all), N = ' ';

Super User
Posts: 7,771

Re: Transposing Proc Tabulate

Posted in reply to DavidPhillips2

Maybe I didn't understand your intention, but wouldn't proc transpose be able to do this, if you saved your tabulate result to a dataset?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 11,343

Re: Transposing Proc Tabulate

Posted in reply to DavidPhillips2

I am guessing here but the only way would be to put the variable into a ROW level expression.

 

Apparently you currently have some something like:

table var all;

You might try:

 

table var all ,

         n

;

 

Exlicitly making the statistic a separate column and the varaible as a row.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 389 views
  • 4 likes
  • 4 in conversation