Date:         Wed, 28 Jun 2006 15:59:55 -0400
Reply-To:     Kevin Roland Viel <kviel@EMORY.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Kevin Roland Viel <kviel@EMORY.EDU>
Subject:      Re: Calculate percentiles 2.5 and 97.5
In-Reply-To:  <200606281948.k5SHjkwK025376@malibu.cc.uga.edu>
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Wed, 28 Jun 2006, Howard Schreier <hs AT dc-sug DOT org> wrote:

> You can use ODS to capture all of the results. Here's a model:
>
>    ods trace on;
>
>    ods output  Univariate.Age.Quantiles=uaq
>                Univariate.Height.Quantiles=uhq
>                Univariate.Weight.Quantiles=uwq
>                ;
>
>    Proc UNIVARIATE data=sashelp.class;
>    VAR age height weight;
>    OUTPUT OUT=MMP2 MAX= Max MIN=Minimum RANGE=Range MEDIAN= Median
>     PCTLPTS=2.5 50 97.5 PCTLPRE= P;
>    run;
>
>    data quantiles;
>    set uaq uhq uwq;
>    run;
>
> This handles just the percentiles.
>
> Unfortunately, the proc seems to produce a large number of small output
> objects, so this approach gets verbose too.

Might this help?

ods noresults ;
ods listing close ;

PROC...

ods results ;
ods listing ;


Kevin Viel
Department of Epidemiology
Rollins School of Public Health
Emory University
Atlanta, GA 30322