Creating summary with mean and std

[abdulla]

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

[novinosrin]

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;

[abdulla]

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. 

[PaigeMiller]

Add to your code above

proc print data=pred2;
run;

[ballardw]

---

@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.