Looking for the easiest way to assign percentile rank for ungrouped data at row level in a result table. Thanks in advance for your suggestions!
Best,
Jordana
In EG this is under TASKS>Data>Rank
You can get the equivalent of percentiles by using GROUPS=100 in the task.
Posting example test data (in the form of a datastep) and what you want the output to look like will improve the answers you get. For now, proc rank would be the one that jumps to mind:
I was wondering if there was a way to do it in EG without programming. If it is a programming requirement, I will give it a try. Thanks for your response 🙂
What does row level ungrouped data mean? Those are not common data terms that I'm familiar with.
Thanks for your response. Perhaps a better way to say it is I will need to assign this value at row level.
Is something like this what you are looking for?
proc rank data=sashelp.class out=ranked groups=100; ranks weightrank; var weight; run;
In EG this is under TASKS>Data>Rank
You can get the equivalent of percentiles by using GROUPS=100 in the task.
Thank very much, worked perfectly.
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.