Identifying top 1% of participants

[Walternate]

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!

[stat_sas · Accepted solution]

Hi,

Try this.

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

   var amount;

   ranks AmountRank;

run;