What is the easiest way to execute percentile rank to assign values at row level for ungrouped data

[Jordana_Anthem]

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

[RW9]

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:

http://support.sas.com/kb/22/759.html

[Jordana_Anthem]

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 🙂

[Reeza]

What does row level ungrouped data mean? Those are not common data terms that I'm familiar with.

[Jordana_Anthem]

Thanks for your response.  Perhaps a better way to say it is I will need to assign this value at row level.

[ballardw]

Is something like this what you are looking for?

proc rank data=sashelp.class out=ranked groups=100;
   ranks weightrank;
   var weight;
run;

[Reeza · Accepted solution]

In EG this is under TASKS>Data>Rank

You can get the equivalent of percentiles by using GROUPS=100 in the task.

[Jordana_Anthem]

Thank very much, worked perfectly.