```Date: Fri, 3 Nov 2006 02:23:11 +0000 Reply-To: toby dunn Sender: "SAS(r) Discussion" From: toby dunn 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 ```

Back to: Top of message | Previous page | Main SAS-L page