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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.