turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- problem with output confidence interval using proc...

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

03-26-2010 12:35 AM

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;

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;

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

03-26-2010 09:25 AM

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

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

03-26-2010 09:27 AM

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.

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.

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

03-26-2010 11:33 AM

Thank you very much!