SAS Enterprise Guide

Desktop productivity for business analysts and programmers
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Jordana_Anthem
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

In EG this is under TASKS>Data>Rank

 

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

View solution in original post

7 REPLIES 7
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
Fluorite | Level 6

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
Super User

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

Jordana_Anthem
Fluorite | Level 6

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

ballardw
Super User

Is something like this what you are looking for?

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

In EG this is under TASKS>Data>Rank

 

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

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 7704 views
  • 1 like
  • 4 in conversation