Help using Base SAS procedures

proc means, output out, standard deviation for mean variables

Accepted Solution Solved
Reply
Contributor
Posts: 33
Accepted Solution

proc means, output out, standard deviation for mean variables

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.


Accepted Solutions
Solution
‎03-22-2012 10:27 AM
Super User
Posts: 10,875

proc means, output out, standard deviation for mean variables

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.

View solution in original post


All Replies
Solution
‎03-22-2012 10:27 AM
Super User
Posts: 10,875

proc means, output out, standard deviation for mean variables

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.

Contributor
Posts: 33

proc means, output out, standard deviation for mean variables

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 260 views
  • 0 likes
  • 2 in conversation