How do I correct the following program;
proc means nway data= para noprint; class Variable; var estimate; output out=two (drop=_type_) mean(estimate)=col1
(1/19)*mean(StdErr)=col2 std(estimate)=col3;
run;
Hi.
I think you need to use an additional data step to create the 1/19 of the mean.
proc means nway data= para noprint; class Variable; var estimate; output out=two (drop=_type_) mean(estimate)=col1
(1/19)*mean(StdErr)=col2 std(estimate)=col3;
run;
data want;
set two;
new_mean = (col1/19)* col2;
run;
This is assuming that you want to calculate 1/19 of the mean times the std Err;
Am I getting this right?
Anca.
Hi.
I think you need to use an additional data step to create the 1/19 of the mean.
proc means nway data= para noprint; class Variable; var estimate; output out=two (drop=_type_) mean(estimate)=col1
(1/19)*mean(StdErr)=col2 std(estimate)=col3;
run;
data want;
set two;
new_mean = (col1/19)* col2;
run;
This is assuming that you want to calculate 1/19 of the mean times the std Err;
Am I getting this right?
Anca.
Thanks a lot
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 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.