sas学习笔记1 merge匹配合并

                       data    test.aa ;                                                                                                
                               input  id $  tj  Ty  age ;                                                                               
                               cards;                                                                                                   
                               1903 87 83 23                                                                                            
                               1902 56 96 22                                                                                            
                               1901 93 75 19                                                                                            
                               1904 77 84 24                                                                                            
                               1908 88 55 18                                                                                            
                               ;                                                                                                        
                               run;                                                                                                     
                               proc print data=test.aa;                                                                                 
                                                                                                                                        
                         data  test.bb;                                                                                                 
                               input   id $ sex $ class;                                                                                
                               cards;                                                                                                   
                               1901 ?? 1                                                                                                
                               1902 ? 1                                                                                                
                               1903 ?? 3                                                                                                
                               1904 ?? 2                                                                                                
                               1905 ? 2                                                                                                
                               1908 ? 3                                                                                                
                               ;                                                                                                        
                               run;                                                                                                     
                               proc print data=test.bb;                                                                                 
                                                                                                                                        
                                                                                                                                        
                                                                                                                                        
                          data test.cc;                                                                                                 
                               merge test.aa test.bb ;                                                                                  
                               by id;                                                                                                   
                               run;                                                                                                     
                                                                                                                                        
                               proc print data=test.cc;

输出如下：