BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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;
2 REPLIES 2
deleted_user
Not applicable
You are SO close.

The problem is that use used the option in the form "Mean = mean". Since there can be only one variable in the output table named "mean" you got the mean (and other statistics) only for the first variable.

There are two ways around this. The first is to specify list, as in
Mean = (mean1 mean2...). The second is to change the output line to

OUTPUT OUT=tmp N MEAN STDERRr LCLM/autoname;

The autoname option will produce an output data set with variables named mean_v1 mean_v2 etc.

Needless to say, the first way is rarely used anymore.

Cheers,

Jonathan

> 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;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 946 views
  • 0 likes
  • 2 in conversation