problem with output confidence interval using proc means

[deleted_user]

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;

[Doc_Duke]

Please just post a question to one forum. You've posted this three times.