topic Re: proc sort does not work in SAS Procedures

proc sort does not work

sasphd — Tue, 11 Apr 2017 13:23:22 GMT

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

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_ — Tue, 11 Apr 2017 13:28:53 GMT

just change your by statement .

proc sort data=have;
by rank_no styleid;

run;

sasphd — Tue, 11 Apr 2017 13:30:36 GMT

if I change the order it will sort only by rank_no

Kurt_Bremser — Tue, 11 Apr 2017 13:31:03 GMT

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