topic Proc Means Excel File Sheet in SAS Procedures

Proc Means Excel File Sheet

ThomasGeorge — Wed, 07 Mar 2012 16:08:21 GMT

proc means data=OSCE_Neph nway nmiss mean std skew Median;

class Station SP_MD;

var Q1resp Q2Resp Q3Resp Q4Resp Q5Resp Q6Resp;

output out = StationsData mean= std= skew= Median=;

run;

How can i get the Mean Std Skew Median of the responses in the final data set? Also in stationsdata i get _type_ as 3 in the rows. Why is that?

Thanks,

Thomas

Re: Proc Means Excel File Sheet

art297 — Wed, 07 Mar 2012 16:28:46 GMT

Thomas,

To get what you want add the autoname option.

You are getting type=3 because you used the nway option which is giving you only the highest level breakdown, which I presume is what you want. You can eliminate that from your output file with a drop statement. e.g.:

proc means data=OSCE_Neph

nway nmiss mean std skew Median noprint;

class Station SP_MD;

var Q1resp Q2Resp Q3Resp Q4Resp Q5Resp Q6Resp;

output out = StationsData (drop=_:)

mean= std= skew= Median= /autoname;

run;

Proc Means Excel File Sheet

ThomasGeorge — Wed, 07 Mar 2012 16:44:36 GMT

Thanks a lot art. I appreciate it. It worked. But i have a question. Will the proc step give me an overall means? Cos right i get the means of each question. Can i get the means of all the stations in the proc step? Or do i have to write another data step for that.

Thanks much.

Proc Means Excel File Sheet

art297 — Wed, 07 Mar 2012 17:21:07 GMT

Remove the nway and drop options. That way you will get all of the combinations specified in your class statement.

Proc Means Excel File Sheet

Ksharp — Thu, 08 Mar 2012 05:25:29 GMT

proc sql;

select mean(mean(Q1resp,Q2Resp,Q3Resp,Q4Resp,Q5Resp,Q6Resp)) as grand_mean

from OSCE_Neph ;

quit;

Ksharp