Transposing Proc Tabulate

Accepted Solution Solved
Reply
Super Contributor
Posts: 483
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: 483

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: 17,905

Re: Transposing Proc Tabulate

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

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

Re: Transposing Proc Tabulate

Found the answer.  My question was rather bad.

 

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

Super User
Posts: 6,963

Re: Transposing Proc Tabulate

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: 10,538

Re: Transposing Proc Tabulate

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
  • 330 views
  • 4 likes
  • 4 in conversation