Date:         Wed, 12 Mar 2003 14:29:44 -0800
Reply-To:     cassell.david@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV>
Subject:      Re: Translation problem
Content-type: text/plain; charset=us-ascii

Nick I <ni14@MAIL.COM> wrote:
> I have the following PROC RANK code which I want to translate into
> PROC SQL code. How do I do this? This code simply takes a (scored)
> column, SCORE_VALUE, and deciles it. That's why I use GROUPS=10.
>
> PROC RANK DATA=A GROUPS=10 OUT=B;
> VAR SCORE_VALUE;
> RANKS DECILE;
> RUN;

Before someone on this list goes much farther, how do you want ties
to be handled?  How about the case where, say, 35% of the data are all
zero?  Or near the median?  In such cases, you need to carefully spell
out how you would want the groups to be assigned...

HTH,
David
--
David Cassell, CSC
Cassell.David@epa.gov
Senior computing specialist
mathematical statistician