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

Sarabjeet_ — Tue, 04 Jun 2019 09:13:26 GMT

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;

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

Kurt_Bremser — Tue, 04 Jun 2019 09:30:18 GMT

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-each-ID-and/m-p/563471?

topic Re: How to get the 4th and 6th Highest Transaction for each ID and the difference in these transacti in SAS Programming

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

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