Hi,
with proc tabulate I have this output :
mean | median | |
Age | 30 | 25 |
Revenue | 2700 | 2600 |
and what I want to have is this form :
Age | mean | 30 |
median | 25 | |
Revenue | mean | 2700 |
median | 2600 |
Is this possible?
Thanks
Based on your previous post, I edited the code because I have only numeric variables :
PROC TABULATE
DATA=SASHELP.CLASS
;
VAR Height Age;
TABLE
/* ROW Statement */
Height * Mean={LABEL="Mean"} Height={LABEL=""} * Median={LABEL="Median"}
Age * Mean={LABEL="Mean"} Age={LABEL=""} * Median={LABEL="Median"} ,
/* COLUMN statement */
ALL=' ' ;
;
RUN;
And I have the result that I want :
Height | Mean | 62.34 |
---|---|---|
Median | 62.80 | |
Age | Mean | 13.32 |
Median | 13.00 |
What I looked for is the " , ALL=' ' "
Thanks a lot @Reeza!
OK, it's a simple code:
proc tabulate data=have;
var age revenue;
tables
/*line*/
age
revenue,
/*column*/
(mean median);
run;
MK
it gives a vertical summary table like this :
Age | Revenue | ||
mean | median | mean | median |
PROC TABULATE
DATA=SASHELP.CLASS
;
VAR Height;
CLASS Sex / ORDER=UNFORMATTED MISSING;
CLASS Age / ORDER=UNFORMATTED MISSING;
TABLE
/* ROW Statement */
Sex *Age *(Height * Mean={LABEL="Average"} Height * Median={LABEL="Median"} ),
/* COLUMN statement */
ALL=' ' ;
;
RUN;
Based on your previous post, I edited the code because I have only numeric variables :
PROC TABULATE
DATA=SASHELP.CLASS
;
VAR Height Age;
TABLE
/* ROW Statement */
Height * Mean={LABEL="Mean"} Height={LABEL=""} * Median={LABEL="Median"}
Age * Mean={LABEL="Mean"} Age={LABEL=""} * Median={LABEL="Median"} ,
/* COLUMN statement */
ALL=' ' ;
;
RUN;
And I have the result that I want :
Height | Mean | 62.34 |
---|---|---|
Median | 62.80 | |
Age | Mean | 13.32 |
Median | 13.00 |
What I looked for is the " , ALL=' ' "
Thanks a lot @Reeza!
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.