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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.