Dear SAS users:
I am trying to calculate means and confidence intervals for multiple variables (e.g 38 variables), listed in a table as 38 columns. My sas code is attached below. Somehow, the means and std can be calculated and print in the window, but the output file (out=tmp) only shows the result for the first variable V1. I am hoping get some help to have the full table with all the variable in it.The output is as follows:
_TYPE_ _FREQ_ n mean stderr lclm uclm
0 96 96 2.701145833 0.038329101 2.625052948 2.777238719
Thanks
pharmpk
filename datain
'd:\ ......csv';
data fulldata;
infile datain DELIMITER=',';
input Prob V1 V2 V3 .....V38;
if prob EQ _blank_ THEN delete;
drop _blank_;
run;
Proc means data=fulldata alpha=0.05;
var V1 V2 V3 .....V38;
OUTPUT OUT=tmp N=n MEAN=mean STDERR=stderr LCLM=lclm UCLM=uclm;
run;