- data a;
- infile datalines;
- input name $ 20. ;
- datalines;
- CityA Enter1
- CityB Enter2
- CityA Enter3
- CityC Enter4
- ;
- run;
- data b;
- infile datalines;
- input city $;
- datalines;
- CityA
- CityB
- ;
- run;
- proc sql;
- create table a_new
- as
- select a.name as Name, aux.city as Where
- from a left join
- (select a.Name as Name, b.City as City
- from a, b
- where find(trim(a.Name), trim(b.City),'i') gt 0) as aux
- on
- a.name=aux.name
- ;
- quit;
结果如下: