Identifying top 1% of participants

Walternate — Fri, 25 Jul 2014 17:41:50 GMT

Hi all,

I'm working with a dataset composed of an ID variable and an amount variable. I need to be able to isolate those participants in the top 1% for highest amounts, but I'm unsure how to do so. That is, I need to know the IDs of those with the top 1% of amount values--not what the 99th percentile amount is.

Any help is much appreciated!

Re: Identifying top 1% of participants

stat_sas — Fri, 25 Jul 2014 18:34:19 GMT

Hi,

Try this.

proc rank data=have out=want descending groups=100 ties=high;

var amount;

ranks AmountRank;

run;

topic Identifying top 1% of participants in SAS Programming

Identifying top 1% of participants

Re: Identifying top 1% of participants