Hi,
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
Example:
ColA ColB
NRI Complex, Palm Beach Raod, Nerul NRI Complex, Seawoods ,Nerul
I have tried doing FuzzyMatching with help of function (COMPGED, Soundlike) 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
I have uploaded a file to demonstrate what I am hoping for..
Thank you
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.