Date: Mon, 14 Aug 2006 13:16:34 -0400
Reply-To: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject: Re: median in proc sql?
On Mon, 14 Aug 2006 11:16:44 -0400, Bob_Abelson@HGSI.COM wrote:
>I only have SAS 8.2 right now, but unless things have changed for Version
>9, the answer is no.
Indeed things have changed (... but; see below).
>1 proc sql;
>2 select median(age) as med_age
>3 from sashelp.class;
>ERROR: Function MEDIAN could not be located.
>NOTE: The SAS System stopped processing this step because of errors.
>NOTE: PROCEDURE SQL used:
> real time 0.03 seconds
> cpu time 0.01 seconds
No error using v. 9.1.3.
But, the result is not the single median for the whole column AGE, but the
trivial set of row-wise medians of single values.
PROC SQL allows use of nearly all SAS functions, so you can code something
like MEDIAN(VAR,2,3) and when VAR=4 for example, you get 3 as the median.
You are using the function as you might in a DATA step. PROC SQL however
does *not* support MEDIAN as a summary stat, so you cannot call for
MEDIAN(VAR) as you might in PROC MEANS.
>240 314 4400 x1374
>Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
>08/14/2006 11:05 AM
>Please respond to
>median in proc sql?
> Does proc sql have a median function?