BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Calcite | Level 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## 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;

2 REPLIES 2
Super User

## 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;

Calcite | Level 5

## Re: Rank multiple variables

Thanks.

Discussion stats
• 2 replies
• 2705 views
• 0 likes
• 2 in conversation