Date: Wed, 20 Sep 2000 11:59:32 -0600
Reply-To: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject: Re: Median Question with PROC SQL
Content-Type: text/plain; charset=us-ascii
Search the archives <http://www.listserv.uga.edu/archives/sas-l.html> for
"median using sql". It will return a posting I made on the subject in March,
plus some additions, clarifications, and comments.
The code came from Joe Celko's "SQL For Smarties", which I strongly
recommend if you're going to be doing anything complicated in SQL.
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California USA
>>> "Girish Patel" <gspatel@PEPCO.COM> 09/20/2000 10:51 AM >>>
Dear SAS-L'rs :
Can it be possible to calculate MEDIAN with PROC SQL ?
PROC SQL ;
SELECT RACE,COUNT(*) AS NUMBER,
AVG(SALARY) AS AVGSAL