Hello everyone, I am stuck at the following issue: I want to filter my Data on two Dates ('31Dec2018'd,'30Nov2018'd), but I only need of each the maximum Version_Number AND then coming from this the maximum Result_ID. Example: Result_ID Version_Number Dates arbitrary_other_variables 3 2 29Dec2018 ... 1 1 30Nov2018 ... 5 4 31Dec2018 ... 6 4 30Nov2018 ... 10 8 31Dec2018 ... Now the Output should be: First filter on the relevant Dates, then pick only those rows, which have the highest Version_Number (at first) and then the highest Result ID. Output should now look like this: Result_ID Version_Number Dates arbitrary_other_variables 6 4 30Nov2018 ... 10 8 31Dec2018 ... So Far, I always need to look up on my self the highest Version number and then coming from this the highest Result ID (which takes a high effort due to great amount of Data ) and enter this data in my code: proc tabulate data=rc_res.creditrisk; var bar_obl_amt zus_obl_amt; class date_dt; WHERE date_DT IN ('31Dec2018'd, '30Nov2018'd) AND AND VERSION_NR IN (4,8) AND RESULT_ID IN (6,10) TABLE (ZUS_OBL_AMT BAR_OBL_AMT), date_dt *( Sum={LABEL="Summe"} ) all = 'Summe' *( Sum={LABEL="Summe"} ) ; run; Is there any code with max or something else which would make it automatically ? Could you please help? I appreciate it a lot and I am really thankful for everyone trying to help me. Kind Regards Alex
... View more