I recommend not using PROC SORT and instead using PROC RANK, which then lets you specify how ties are handled. If you use PROC SORT, and the tenth and eleventh item are tied, then when you print out the Top 10, you miss the fact that there was a tie and you won't see the 11th item which has the same value as the 10th item.
proc rank data=mlb ties=low out=mlb_ranked descending;
var salaries;
ranks salaries_ranked;
run;
proc print data=mlb_ranked(where=(salaries_ranked<=10));
format Salary dollar12.3;
run;
The above is one method of handling ties, the PROC RANK documentation lists the other possible options.
... View more
