https://communities.sas.com/t5/SAS-Data-Science/Fuzzy-Matching/m-p/241343#M9524 <P>Hi,</P><P>&nbsp;</P><P>I need code to fuzzy Match on two lists of address "LookIn" list in Col A "LookFor" list in ColB on sheet1, both list are different in the shape. Some times Col A is longer then Col B sometimes the opposite is true. Col A is the master list an Col B where a match exists is either a exact match or a misspelling or a different way writing the name e.g</P><P>&nbsp;</P><P>Example:</P><P>ColA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;ColB&nbsp;</P><P>NRI Complex,&nbsp;Palm Beach Raod, Nerul&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NRI Complex, Seawoods ,Nerul&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>I have tried&nbsp;doing FuzzyMatching with help of function (COMPGED, Soundlike)&nbsp;but showed inconsistent results. I need where there is a fuzzy match to have best matches placed in the adjacent cells in the same row next to the cell that was matched, all exact matches can be ignored</P><P>&nbsp;</P><P>I have uploaded a file to demonstrate what I am hoping for..</P><P>&nbsp;</P><P>Thank you</P> Thu, 31 Dec 2015 05:23:47 GMT ramesh31 2015-12-31T05:23:47Z https://communities.sas.com/t5/SAS-Data-Science/Fuzzy-Matching/m-p/241343#M9524 <P>Hi,</P><P>&nbsp;</P><P>I need code to fuzzy Match on two lists of address "LookIn" list in Col A "LookFor" list in ColB on sheet1, both list are different in the shape. Some times Col A is longer then Col B sometimes the opposite is true. Col A is the master list an Col B where a match exists is either a exact match or a misspelling or a different way writing the name e.g</P><P>&nbsp;</P><P>Example:</P><P>ColA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;ColB&nbsp;</P><P>NRI Complex,&nbsp;Palm Beach Raod, Nerul&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NRI Complex, Seawoods ,Nerul&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>I have tried&nbsp;doing FuzzyMatching with help of function (COMPGED, Soundlike)&nbsp;but showed inconsistent results. I need where there is a fuzzy match to have best matches placed in the adjacent cells in the same row next to the cell that was matched, all exact matches can be ignored</P><P>&nbsp;</P><P>I have uploaded a file to demonstrate what I am hoping for..</P><P>&nbsp;</P><P>Thank you</P> Thu, 31 Dec 2015 05:23:47 GMT https://communities.sas.com/t5/SAS-Data-Science/Fuzzy-Matching/m-p/241343#M9524 ramesh31 2015-12-31T05:23:47Z https://communities.sas.com/t5/SAS-Data-Science/Fuzzy-Matching/m-p/241410#M9525 I like the solution from FriedEgg here:<BR /><A href="https://communities.sas.com/t5/SAS-Procedures/Name-matching/m-p/82780/highlight/true#M23757" target="_blank">https://communities.sas.com/t5/SAS-Procedures/Name-matching/m-p/82780/highlight/true#M23757</A> Thu, 31 Dec 2015 18:05:09 GMT https://communities.sas.com/t5/SAS-Data-Science/Fuzzy-Matching/m-p/241410#M9525 Reeza 2015-12-31T18:05:09Z