topic Re: Need help to rank the data in SAS Programming

Need help to rank the data

Aman4SAS — Wed, 06 Sep 2017 05:41:18 GMT

Hi All,

I need to rank my data.

id var1 var2 var3

1 10 5 24

2 20 7 32

3 30 20 62

4 30 30 98

5 30 30 63

6 40 45 21

7 40 75 33

8 50 60 90

My challage is : I need to rank the data base on priotize variable

example first priority variable is var1 but if var1 is duplicate then need to check var2 if var2 also duplicate then need to check var3

priority level is var1 then var2 then var3

i would be very thankful for ur help.

Re: Need help to rank the data

PeterClemmensen — Wed, 06 Sep 2017 06:37:54 GMT

What does your desired output look like?

Re: Need help to rank the data

user24feb — Wed, 06 Sep 2017 07:04:38 GMT

Isn't that what proc sort .. by var1 var2 var3 is doing?

Re: Need help to rank the data

andreas_lds — Wed, 06 Sep 2017 07:07:20 GMT

A look-ahead seems to be the method to solve the problem. Explained here: http://support.sas.com/resources/papers/proceedings10/103-2010.pdf

Re: Need help to rank the data

PeterClemmensen — Wed, 06 Sep 2017 07:09:12 GMT

If that is the case then do


data have;
input id var1 var2 var3;
datalines;
1 10 5  24
2 20 7  32
3 30 20 62
4 30 30 98
5 30 30 63
6 40 45 21
7 40 75 33
8 50 60 90
;

proc sort data=have;
	by var1-var3;
run;