统计每个个体出现3和4的次数

1. data aaa;
   
2. input id$ trt x;
   
3. cards;
   
4. 1 1 0
   
5. 1 1 1
   
6. 1 1 .
   
7. 1 1 2
   
8. 1 1 2
   
9. 2 1 0
   
10. 2 1 2
    
11. 2 1 3
    
12. 2 1 4
    
13. 2 1 .
    
14. 3 2 0
    
15. 3 2 3
    
16. 3 2 3
    
17. 3 2 4
    
18. 3 2 4
    
19. 4 2 0
    
20. 4 2 .
    
21. 4 2 .
    
22. 4 2 3
    
23. 4 2 .
    
24. ;
    
25. run;

复制代码

id为个体 trt为组别
希望得到的数据集为
id trt x1
1  1  0
2  1  2
3  2  4
4  2  1
谢谢！

1. proc sort data=aaa; by id; run;
   
2. data x1; set aaa;
   
3. by id;
   
4. retain x1;
   
5. if first.id then x1=0;
   
6. if x in (3,4) then x1=x1+1;
   
7. if last.id then output;
   
8. drop x;
   
9. run;

复制代码

proc sql;
create table wanted as
select id, trt, sum(x=3 or x=4) as x1
from aaa
group by 1,2;
quit;