This is very close to what I am looking for but what if I want the top 10 by Jurisdiction and also by Date. This is my sample code for top 10 by Jurisdiction proc sort data=ATM_TOP_VALUE out = ATM_TOP_VALUE1; by Jurisdiction descending amount; run; data ATM_TOP_VALUE2; set ATM_TOP_VALUE1; by Jurisdiction; if first.Jurisdiction = 1 then cnt = 0; cnt + 1; if cnt <= 10; if last.Jurisdiction = 1 then cnt = 0; run; However there is a field called month of and I want the top 10 for each jurisdiction for each month. How would I have to change the above code to get that?
... View more