## Rank multiple variables

Solved
Occasional Contributor
Posts: 5

# Rank multiple variables

Hi. I have the following code:

proc rank data=DATA_RANK groups=10 descending out=ranked;
var SCORE_1;
ranks GROUP_1;
var SCORE_2;
ranks GROUP_2;
run;

What I need to do is split out the data into two separate groups so a score of 0-9 for SCORE_1 and 0-4 for SCORE_2. I am effectively trying to split the data set into equal deciles and quintiles. Any help would be much appreciated.

Accepted Solutions
Solution
‎05-03-2016 10:24 AM
Super User
Posts: 13,583

## Re: Rank multiple variables

Take two passes through Proc Rank.

proc rank data=DATA_RANK groups=10 descending out=ranked;
var SCORE_1;
ranks GROUP_1;

run;
proc rank data=ranked groups=4 descending out=rankedfinal;

var SCORE_2;
ranks GROUP_2;
run;

All Replies
Solution
‎05-03-2016 10:24 AM
Super User
Posts: 13,583

## Re: Rank multiple variables

Take two passes through Proc Rank.

proc rank data=DATA_RANK groups=10 descending out=ranked;
var SCORE_1;
ranks GROUP_1;

run;
proc rank data=ranked groups=4 descending out=rankedfinal;

var SCORE_2;
ranks GROUP_2;
run;

Occasional Contributor
Posts: 5

## Re: Rank multiple variables

Thanks.

🔒 This topic is solved and locked.