如何取出id x组合下x1为最大值的观测？

1. data bbb;
   
2. input id x x1;
   
3. cards;
   
4. 1 2 1
   
5. 1 2 2
   
6. 1 2 4
   
7. 1 3 1
   
8. 1 3 2
   
9. 1 3 5
   
10. 1 3 6
    
11. 2 1 1
    
12. 2 1 2
    
13. 2 2 1
    
14. 2 2 2
    
15. ;
    
16. run;
    
17. 
    
18. 
    
19. data ccc;
    
20.         set bbb;
    
21.         by id x x1;
    
22.         if last.x1 then output;
    
23. run;

复制代码

如何取出id x组合下x1为最大值的观测？谢谢！
1 2 4
1 3 6
2 1 2
2 2 2

data ccc;
        set bbb;
        by id x x1;
        if last.x then output;
run;

试试这个
data aa;
set bbb;
idx=compress(id," ")||compress(x," ");
run;
proc sql;
create table a as
select id,x,max(x1) as x1
from aa
  group by idx;
quit;
proc sort data=a nodupkey;
by id  x;
run;