topic Re: Help in Rank function in SAS Programming

Help in Rank function

Kalai2008 — Wed, 26 Jul 2017 19:34:59 GMT

Please help! I want to Rank the second variable in this code.

data have;
input id region;
datalines;
10 US
10 CA
10 CA
23 MA
25 MA
45 Ks
50 US
50 SA
65 US
;

proc sort data = have;
by id;
run;

data want;
set have;
by id;
if first.id then rank =1;
else rank+1;
run;

Output needed:

ID Rank1 Rank2

10 1 1

10 2 1

10 3 2

Re: Help in Rank function

ballardw — Wed, 26 Jul 2017 19:38:39 GMT

What is your rule for ranking a character variable?

Since you have US within 3 of the ID groups it isn't clear what that rule may be.

Also you might want to work the result for all of your example data and not remove the Region variable.

Re: Help in Rank function

Kalai2008 — Wed, 26 Jul 2017 19:46:19 GMT

Thank you, My rule is to Rank a new column when the variable is US, Another Column to Rank, for CA separately and one column with no rules.(which I already got it from the prev query)

Re: Help in Rank function

Reeza — Wed, 26 Jul 2017 19:55:39 GMT

https://stats.idre.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/

Instructions above for the various situations you're working with.

Re: Help in Rank function

Kalai2008 — Wed, 26 Jul 2017 21:05:34 GMT

Thank you Reeza!.. Great article! It helps!