topic output format of proc means with chosen variables in SAS Programming

output format of proc means with chosen variables

ilikesas — Mon, 19 Sep 2016 03:38:37 GMT

Hi,

I have 3 variables (a,b,c) for which I want to do calulate n, mean and median and then output the result.

Here is the code and the "want" output:

proc means data=have n mean median ;
var a b c ;
output out = want ;
run;

type	freq	statistic	a	b	c
		n
		min
		max
		mean
		std

Since I want the n, mean and media I do the following adjustment:

proc means data=have n mean median ;
var a b c ;
output out = want n=n mean=mean median=median ;
run;

But here the "want" output table is of the following form:

type	freq	n	mean	median

here the n, mean and median become columns and I get only 1 row corresponding to variable a, statistics for variables b and c simply don't show.

So is it possible to have the original form of output but for the chosen statistics, so that the "want" output table looks like this:

type	freq	statistic	a	b	c
		n
		mean
		median

Thank you!

Re: output format of proc means with chosen variables

Reeza — Mon, 19 Sep 2016 03:49:43 GMT

Try the ODS table and Google STACKODS option.

Re: output format of proc means with chosen variables

Astounding — Mon, 19 Sep 2016 07:47:20 GMT

Switching to PROC TABULATE will make a lot of this easy:

proc tabulate data=have;

var a b c;

tables n mean median, a b c;

run;

See if it comes close enough. You might want to add NMISS to the list of statistics, since you are no longer getting _FREQ_. It's not clear why you would want _TYPE_ at all, so that part is not included.

Re: output format of proc means with chosen variables

Ksharp — Mon, 19 Sep 2016 09:39:18 GMT

3)
proc univariate data=have outtable=want noprint;
var a b c;
run;

Re: output format of proc means with chosen variables

data_null__ — Mon, 19 Sep 2016 14:48:14 GMT

https://communities.sas.com/t5/Base-SAS-Programming/Proc-Summary-Help/m-p/295114#M61633