topic Rank multiple variables in SAS Procedures

Rank multiple variables

serveoverice — Tue, 03 May 2016 14:09:37 GMT

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.

Re: Rank multiple variables

ballardw — Tue, 03 May 2016 14:20:32 GMT

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;

Re: Rank multiple variables

serveoverice — Tue, 03 May 2016 14:24:28 GMT

Thanks.