Date:         Mon, 17 Aug 2009 20:43:47 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Hot to break 100 observations into 20% break
Comments: To: Pareen Patel <mditconsult@GMAIL.COM>

You probably want something more than what you asked for, but:

data have;
  input obs Mem  gender $;
  cards;
1     1   male
2     1   male
3     1   unknow
4     1   female
5     1   male
6     1   male
7     1   female
8     1   female
9     1   female
10    1   male
;

proc rank data=have out=want percent;
  var obs;
  ranks obspct;
run;

proc format;
  value percents
  0-20='top 20%'
  20-40='2nd 20%'
  40-60='3nd 20%'
  60-80='4th 20%'
  80-100='5th 20%'
;
run;

data want;
  set want;
  format obspct percents.;
run;

HTH,
Art
-------
On Mon, 17 Aug 2009 19:37:32 -0400, Pareen Patel <mditconsult@GMAIL.COM>
wrote:

>Hey if someone could help me please understanding.
>I know hot to get top 20% of 100 Observations.
>
>For e.g. i have
>
>obs. Mem  gender
>1     1   male
>2     1   male
>3     1   unknow
>4     1   female
>5     1   male
>6     1   male
>7     1   female
>8     1   female
>9     1   female
>10    1   male
>
>I would like to see them in in groups of To 20%, 2nd 20%, 3rd 20% and so on
>
>Like
>Top 20%
>
>obs mem gender
>1  1 male
>2  1 male
>
>2nd 20%
>
>obs mem gender
>3 1 unknown
>4 1 female
>
>3rd 20%
>
>obs mem gender
>5 1 male
>6 1 male
>
>Regards & Thanks