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;

[Paige]

OUTPUT OUT=tmp N=n1-n38 MEAN=mean1-mean38 STDERR=stderr1-stderr38 LCLM=lclm1-lclm38 UCLM=uclm1-uclm38;

[Doc_Duke]

You are missing the <(variable)> specification in your OUTPUT statement. See the documentation and examples.

statistic-keyword<(variable-list)>=

would look like

mean(V1 V2)=MeanV1 MeanV2

to get means for V1 and V2.

If you want one row per variable, use TRANSPOSE first to rearrange and add a CLASS statement to PROC MEANS.

[deleted_user]

Thank you very much!