- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
In EG this is under TASKS>Data>Rank
You can get the equivalent of percentiles by using GROUPS=100 in the task.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What does row level ungrouped data mean? Those are not common data terms that I'm familiar with.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your response. Perhaps a better way to say it is I will need to assign this value at row level.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Is something like this what you are looking for?
proc rank data=sashelp.class out=ranked groups=100; ranks weightrank; var weight; run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
In EG this is under TASKS>Data>Rank
You can get the equivalent of percentiles by using GROUPS=100 in the task.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank very much, worked perfectly.