topic Re: Creating summary with mean and std in All Things Community

Creating summary with mean and std

abdulla — Sun, 10 Feb 2019 23:54:05 GMT

Hi,

I have used the following code to get mean and std. I am getting results separately in 5 different tables for each group. How can I get the results in one summary table?

proc means data=triangle mean std;
var y;
by trt;
output out=pred2 mean= std= /autoname;
run;

I want results like the following. Please help

trt	mean	std	N
1
2
3
4
5

Re: Creating summary with mean and std

novinosrin — Sun, 10 Feb 2019 23:45:36 GMT

i think you are missing nway option


proc means data=triangle mean std nway;
var y;
by trt;
output out=pred2 mean= std= /autoname;
run;

Re: Creating summary with mean and std

abdulla — Sun, 10 Feb 2019 23:55:00 GMT

No, I am still not getting what I want. I am getting results in 5 different tables for 5trt. But I want them in one table.

Re: Creating summary with mean and std

PaigeMiller — Mon, 11 Feb 2019 13:16:29 GMT

Add to your code above

proc print data=pred2;
run;

Re: Creating summary with mean and std

ballardw — Mon, 11 Feb 2019 15:12:00 GMT

@abdulla wrote:

Hi,

I have used the following code to get mean and std. I am getting results separately in 5 different tables for each group. How can I get the results in one summary table?

proc means data=triangle mean std;
var y;
by trt;
output out=pred2 mean= std= /autoname;
run;

I want results like the following. Please help

trt mean std N

1

2

3

4

5

Try

CLASS trt;

BY does what you are saying: it creates separate output for each level of the BY Variable. CLASS creates grouped output.