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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.