Need help to rank the data

[Aman4SAS]

 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.

[PeterClemmensen]

What does your desired output look like?

[user24feb]

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

[andreas_lds]

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

[PeterClemmensen]

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;