BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DavidPhillips2
Rhodochrosite | Level 12

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

1 ACCEPTED SOLUTION

Accepted Solutions
DavidPhillips2
Rhodochrosite | Level 12

Found the answer.  My question was rather bad.

 

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

View solution in original post

4 REPLIES 4
Reeza
Super User

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

DavidPhillips2
Rhodochrosite | Level 12

Found the answer.  My question was rather bad.

 

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

ballardw
Super User

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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