topic Re: horizontal summary table in ODS and Base Reporting

horizontal summary table

majdi_ka — Thu, 26 Nov 2015 15:53:52 GMT

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

Re: horizontal summary table

Reeza — Thu, 26 Nov 2015 16:02:11 GMT

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

Re: horizontal summary table

majdi_ka — Thu, 26 Nov 2015 16:30:36 GMT

@Reeza,

OK, it's a simple code:

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

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

Re: horizontal summary table

Reeza — Thu, 26 Nov 2015 16:31:47 GMT

What does the following give you:

tables (age revenue)*(mean median);

Re: horizontal summary table

majdi_ka — Thu, 26 Nov 2015 16:34:55 GMT

it gives a vertical summary table like this :

Age		Revenue
mean	median	mean	median

Re: horizontal summary table

Reeza — Thu, 26 Nov 2015 16:43:22 GMT

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;

Re: horizontal summary table

majdi_ka — Thu, 26 Nov 2015 17:01:56 GMT

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!