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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.