topic proc means, output out, standard deviation for mean variables in SAS Procedures

proc means, output out, standard deviation for mean variables

jdub — Thu, 22 Mar 2012 14:19:57 GMT

Howdy

How would I output the results from a proc means to a SAS data set? I know how to output out a mean of a collapsed variable but I also need to output out the standard deviation for each collapsed variable.

Here is what I can do:

proc means data=digit;

by x;

var y;

output out=means mean=ybar;

run;

Is there a statement I could use to create a std dev for y?

I appreciate any help someone could give me.

proc means, output out, standard deviation for mean variables

ballardw — Thu, 22 Mar 2012 14:27:30 GMT

I'm not sure what you mean by collapsed variable but to add standard deviation to your output add

std= ystd after mean=ybar.

If you want to process more variables such as with :

var var1 var2 var3 ... ;

you could use

output out=<datasetname> mean= std= <other requested statistics> / autoname;

The autoname option will create variable names based on your variable name and the requested statistic so you don't have to.

proc means, output out, standard deviation for mean variables

jdub — Thu, 22 Mar 2012 14:48:44 GMT

thank ya.

by collapsed obs I was trying to say that the mean of y was generated by x over a basket of time points but did a poor job of communicating this