How to get the 4th and 6th Highest Transaction for each ID and the difference in these transactions

[Sarabjeet_]

Hi All,

 

I am new to SAS, want to know how I can get the difference between the 4th highest and 6th highest transaction of each ID

 

 

Sample Data: 

data a;
input id transaction;
cards;
1 200
1 300
1 100
1 500
1 600
1 400
1 700
2 300
2 200
2 300
2 400
2 500
2 800
2 900
2 350
3 200
3 150
3 100
3 50
3 400
3 600
3 900
3 450
3 90
;
run;

[Kurt_Bremser]

Have both of you gotten the same homework: https://communities.sas.com/t5/SAS-Programming/How-to-get-the-4th-and-6th-Highest-Transaction-for-ea...?