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
Found the answer. My question was rather bad.
table (application_type = ' ' all), N = ' ';
Not sure I follow. Can you show a more detailed example?
Found the answer. My question was rather bad.
table (application_type = ' ' all), N = ' ';
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?
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.