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
Comments: To: gspatel@PEPCO.COM
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.




--
JackHamilton@FirstHealth.com
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
FROM STEP2