Hello, I have this dataset: I am presenting this table with fname and lname, but both variables should be perfect match if we are going to match it using fuzzy matching because they are from same people with different version. Obs fname lname 1 Morales De Rodriguez Morales-Rodriguez 2 Morales De Rodriguez Morales – Rodriguez 3 Morales De Rodriguez Morales Rodriguez 4 Morales De Rodriguez MoralesRodriguez 5 Morales De Rodriguez Morales – De – Rodriguez 6 Morales-Rodriguez Morales De Rodriguez 7 Morales Rodriguez MoralesDeRodriguez I am using this code to match it. data final2;
set work.final;
delims = ' ,.!–-';
fname2= compress(fname, delims);
lname2 =compress(lname, delims);
score_compged=compged(fname2, lname2, 'INL');
score2_complev=complev(fname2, lname2, 'INL');
run;
proc print data=final2;
run;
ods rtf close; Do you have any better code than this one? Thanks, Bikash
... View more