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 |
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;
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.
Add to your code above
proc print data=pred2;
run;
@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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!