Hi @DaveLarge
I have tried something like this. Please test it on several cases so that you can see if it sensitive / specific enough.
data a;
infile datalines dlm="09"x;
input Name:$20. Long Lat;
datalines;
Midgar 34 64
;
run;
data b;
infile datalines dlm="09"x;
input Possible_Name:$20. Details_1:$20. Details_2:$20.;
datalines;
75 MidGAR street need this And and this
;
run;
proc sql;
select a.Name, b.Possible_Name, a.Long, a.Lat, b.Details_1, b.Details_2
from a full join b /* select the proper type of join */
on find(compress(b.Possible_Name," "), compress(a.Name," "), "i") > 0;
quit;
Hope this helps!
Best,
... View more