Date:         Fri, 3 Nov 2006 02:23:11 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: calculating lowest one third of total population
Comments: To: gopilth@YAHOO.COM
In-Reply-To:  <1162519486.946357.304390@k70g2000cwa.googlegroups.com>
Content-Type: text/plain; format=flowed

Not totally sure exactly what all your rules will need to be:


Data Have ;
Infile Cards ;
Input Id Points ;
Cards ;
1  512
2  512
3  618
4  620
5  620
6  625
7  650
8  651
9  700
10 701
;
Run ;


Proc Rank
  Data = Have
   Out = Need ;
   Var Points ;
   Ranks PointRanks ;
Run ;

Proc Print
Data = Need ;
Where PointRanks <= 6 ;
Run ;




Toby Dunn


You never know what is enough, until you know what is more than enough.
~William Blake, Proverbs of Hell


When the student is ready, the master appears.  ~Buddhist Proverb


Only that in you which is me can hear what I'm saying.  ~Baba Ram Dass





From: gopilth@YAHOO.COM
Reply-To: gopilth@YAHOO.COM
To: SAS-L@LISTSERV.UGA.EDU
Subject: calculating lowest one third of total population
Date: Thu, 2 Nov 2006 18:04:47 -0800

Hi,
I have a sample data set as follows
id    points
1      512
2      512
3      618
4      620
5      620
6      625
7      650
8      651
9      700
10    701
and so on......
of these i need to get the subjects in  lowest one sixth of total
subjects based on points.can anyone please help me
Thank you,

_________________________________________________________________
Stay in touch with old friends and meet new ones with Windows Live Spaces
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us