数据集合并

生命不息

匹配合并（有by）

1. data identity;
   
2. input id sex $ age;
   
3. cards;
   
4. 1001 f 20
   
5. 1003 m 22
   
6. 1002 m 20
   
7. 1001 f 21
   
8. ;
   
9. 
   
10. proc sort data=identity;
    
11. by id;
    
12. run;
    
13. data score;
    
14. input id language $ score;
    
15. cards;
    
16. 1001 English 90
    
17. 1002 Chinese 93
    
18. 10001 France 83
    
19. ;
    
20. proc sort data=score;
    
21. by id;
    
22. run;
    
23. data result;
    
24. merge identity score;
    
25. by id;
    
26. run;
    
27. proc print data=result;
    
28. run;

复制代码

一对一合并（无by）

1. data me;
   
2. input id sex $ math;
   
3. cards;
   
4. 12 m 80
   
5. 13 m 76
   
6. 14 m 96
   
7. ;
   
8. proc print data=me;
   
9. run;
   
10. 
    
11. data mad;
    
12. input id sex $ English Chinese;
    
13. cards;
    
14. 12 F 93 76
    
15. 13 F 89 78
    
16. ;
    
17. data score;
    
18. merge me mad;
    
19. run;
    
20. proc print;
    
21. run;

复制代码