topic What is the easiest way to execute percentile rank to assign values at row level for ungrouped data in SAS Enterprise Guide

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

Jordana_Anthem — Mon, 08 May 2017 15:15:04 GMT

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

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

RW9 — Mon, 08 May 2017 15:24:20 GMT

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

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

Reeza — Mon, 08 May 2017 15:29:15 GMT

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

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

Jordana_Anthem — Mon, 08 May 2017 15:34:30 GMT

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 🙂

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

Jordana_Anthem — Mon, 08 May 2017 15:35:31 GMT

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

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

ballardw — Mon, 08 May 2017 15:42:14 GMT

Is something like this what you are looking for?

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

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

Reeza — Mon, 08 May 2017 15:48:13 GMT

In EG this is under TASKS>Data>Rank

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

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

Jordana_Anthem — Tue, 09 May 2017 17:44:51 GMT

Thank very much, worked perfectly.