topic Re: Proc Means output to dataset issue in Statistical Procedures

Proc Means output to dataset issue

pessi — Tue, 20 Apr 2021 11:14:16 GMT

Hi,

I am running below code

proc means data = p_tra
qntldef=5
mean median min q3 q1 max stddev n ;
var Baseline "Follow-up 1"n "Follow-up 2"n "Follow-up 3"n;
output out=p_tra_out ;
run;

Output:

Variable	Mean	Median	Minimum	Upper Quartile	Lower Quartile	Maximum	Std Dev	N
Baseline	1.944444	1	1	4	1	5	1.589385	18
Follow-up 1	1.777778	1	1	1	1	5	1.516791	18
Follow-up 2	1.6	1	1	1	1	5	1.298351	15
Follow-up 3	.	.	.	.	.	.	.	0

It is giving me perfect output what I wanted whole displying the output of PROC Means.

But, When I want the same output in output work dataset, I am not getting that.

Tried of using mean= median=, but no use.
Without specifying any options, I am getting default vars N,Min,Max,Mean,STD. along with them I want Median, Q3, Q1 as well in output dataset.

Could someone tell me how to get output dataset with all variables like proc means output.

Thanks,

Pessi

Re: Proc Means output to dataset issue

PaigeMiller — Tue, 20 Apr 2021 11:22:57 GMT

Use the STACKODS option and ODS OUTPUT

ods output summary=outputdatasetname;
proc means data = sashelp.class stackods qntldef=5 mean median min q3 q1 max stddev n ;
    var height weight;
run;

From now on, please enter code in a code box (as I have done above) by clicking on the "running man" icon and pasting your code into the window that appears.

Re: Proc Means output to dataset issue

pessi — Tue, 20 Apr 2021 11:32:54 GMT

@Paige Miller: Thank You. It worked.
Sure. I will do from next time onwords.