topic Re: Transposing Proc Tabulate in SAS Programming

Transposing Proc Tabulate

DavidPhillips2 — Mon, 03 Oct 2016 14:31:52 GMT

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

Reeza — Mon, 03 Oct 2016 14:32:30 GMT

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

Kurt_Bremser — Mon, 03 Oct 2016 14:34:38 GMT

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?

DavidPhillips2 — Mon, 03 Oct 2016 14:34:44 GMT

Found the answer. My question was rather bad.

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

ballardw — Mon, 03 Oct 2016 14:36:52 GMT

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 ,

;

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