Advanced Search

Return to Snippet

Revision: 6176
at May 3, 2008 15:26 by webonomic
Initial Code 
Data  DS1;
INPUT A $ B $ C $ ;
Cards ;
Small Tike Red
Med Bike Blue
Large Bike Red
;

Data DS2 ;
INPUT X $ Y $ Z $ ;
Cards ;
Small 10.99 1yr
Small 20.99 2yr
Large 50.00 1yr
;

run;

proc sql;
create table AllDS as
 select coalesce(ds1.a,ds2.x) as ax, b, c, y, z
  from ds1 full join ds2
  on ds1.a = ds2.x
  order by ax desc;
quit;
Initial URL 
http://jaredprins.squarespace.com/blog/2008/5/3/merge-datasets-with-unlike-variable-names.html
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Merge datasets with unlike variable names

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SAS