Date: Thu, 13 Jan 2005 12:55:44 -0800
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV>
Subject: Re: Quantile statistics in PROC MEANS
Content-type: text/plain; charset=US-ASCII
A Little Birdie(tm) wrote me and pointed out:
me> You can get the same, precise estimates either using PROC UNIVARIATE
me> or using PROC MEANS. They both use the same engine under the hood
me> these days.
MEANS and SUMMARY are the same under the hood, but UNIVARIATE is quite
different. UNIVARIATE builds a tree of data values for each variable.
MEANS builds trees of class values but not of data values. Most of the
computations in MEANS are done with one or two passes over the data
set without storing the data internally like UNIVARIATE does. The exact
quantiles are the only statistics in MEANS that require storing the
data internally that I know of.
So now you know.
On a related note, the memory and time requirements of PROC UNIVARIATE
or PROC MEANS using QMETHOD=OS can be tackled with a different approach.
PROC STDIZE can find quantiles in a single pass of the data, a
that can be very useful for large data sets (as in our other thread).
David Cassell, CSC
Senior computing specialist