topic retrieving output from procedures in SAS Procedures

retrieving output from procedures

BrentFulton — Tue, 18 Oct 2011 14:08:21 GMT

Hi,

I would like to write SAS code so output from procedures is automatically put into a table. For example, if I run proc means data=data1 mean N NMISS on 15 variables, I would like the output to go into a table with four columns (variable name, mean, N, NMISS) and 15 rows (one for each variable). Is that possible? I can do this in Stata, because all output is stored in scalars and matrices, which can be accessed and put into a matrix (i.e., table) that I create.

Thanks,

Brent Fulton

UC Berkeley

Re: retrieving output from procedures

Howles — Tue, 18 Oct 2011 15:33:24 GMT

See

http://www.sascommunity.org/wiki/PROC_MEANS_-_Improve_on_the_default

BrentFulton wrote:

Hi,

Thanks,

Brent Fulton

UC Berkeley

Re: retrieving output from procedures

data_null__ — Tue, 18 Oct 2011 16:01:35 GMT

Be aware that the last time I looked this program did not produce 2-sided confidence intervals as you would expect when both are Upper and Lower CI are requested.

Re: retrieving output from procedures

Tom — Tue, 18 Oct 2011 17:11:56 GMT

Almost all procedure will now deliver the output into datasets for you using the ODS output system.

http://support.sas.com/documentation/cdl/en/odsug/62755/HTML/default/viewer.htm

Also many procedures have options to specify output datasets.

In particular for PROC MEANS/SUMMARY there is the OUTPUT statement.

retrieving output from procedures

Peter_C — Wed, 19 Oct 2011 14:52:31 GMT

Tom

before SAS9.3, ODS OUTPUT wasn't generating the layout that seemed natural in the output window (and I'm not sure if it will now - in 9.3). So Myra Olstik started her project to automate the process of creating a column for each variable with a row for each requested statistic.The results of that project are described in a paper with the macro code, that can be found at the link offered above, by Howles http://www.sascommunity.org/wiki/PROC_MEANS_-_Improve_on_the_default

As you suggest, the solution uses the output statement (one for each statistic).

peterC