proc sort does not work

[sasphd]

I want to sort data by styleid and rank_no 

I want this result

rank_no styleid

1 3

1 4

2 1

2 2

3 2

but using my program I obtain

2 1

2 1

3 2

1 3

1 4

as if the data is sorted only by styleid

data have;
input rank_no$ styleid$;
cards;
2 1
3 2
2 2
1 3
1 4
run;
proc sort data=have;
by styleid rank_no ; run;

[kiranv_ · Accepted solution]

just change your by statement .

proc sort data=have;
by rank_no  styleid;

run;

[sasphd]

if I change the order it will sort only by rank_no

[Kurt_Bremser]

You get exactly what you told proc sort to do.

According to your expected result, you need to change the order of variables in the by:

proc sort data=have;
by rank_no styleid;
run;

The result from that is

rank_no    styleid

   1          3   
   1          4   
   2          1   
   2          2   
   3          2