BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Walternate
Obsidian | Level 7

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!

1 ACCEPTED SOLUTION

Accepted Solutions
stat_sas
Ammonite | Level 13

Hi,

Try this.

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

   var amount;

   ranks AmountRank;

run;

View solution in original post

1 REPLY 1
stat_sas
Ammonite | Level 13

Hi,

Try this.

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

   var amount;

   ranks AmountRank;

run;

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 882 views
  • 0 likes
  • 2 in conversation