In reply to Lysbet.

Lysbet,

Read my white paper on "Fuzzy Merge / Match" which I published back in 1998 - It was published in SAS Observation Magazine - I still have the paper on my website under SAS Tips and the actual SAS code is included with the paper.

I use the routine to match records between two files using such fields as “Name”, “Address”, “City”, “State”, and “can be Zipcode”. It all depends on what information/data each file has that can be used to match on. The code does not care if Name=”Charles Patridge” is in file One, and then Name in file Two has it as “Partridge, Chuck” – ie, the order of how data is stored is NOT important.

http://www.sconsig.com/sastips/obswww15.pdf

HTH,
Chuck Patridge