Help using Base SAS procedures

Rank multiple variables

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

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
Grand Advisor
Posts: 10,026

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;

View solution in original post


All Replies
Solution
‎05-03-2016 10:24 AM
Grand Advisor
Posts: 10,026

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.

Need further help from the community? Please ask a new question.

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