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


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;

Initial URL

Initial Description

Initial Title
Merge datasets with unlike variable names

Initial Tags

Initial Language