horizontal summary table

[majdi_ka]

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

[Reeza]

Yes, change your table statement. If you post your code, someone can suggest the change from the current code.

[majdi_ka]

@Reeza,

OK, it's a simple code:

proc tabulate data=have;
  var age revenue;
  tables
     /*line*/
     age
     revenue,

     /*column*/
     (mean median);
run;

      

MK

[Reeza]

What does the following give you:

tables (age revenue)*(mean median);

[majdi_ka]

it gives a vertical summary table like this :

Age		Revenue
mean	median	mean	median

[Reeza]

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;

[majdi_ka · Accepted solution]

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!