Rank multiple variables

[serveoverice]

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.

[ballardw · Accepted solution]

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;

[serveoverice]

Thanks.