I am looking for a specific employer in a SAS data set. The data set has not been reviewed for spelling so if I am looking for University it could be entered as Unversity, University, Univercity ... and I need to pick them all up
I've tried scaning, counting the matching letters, 'contains'. These are work but I am still missing some.
Any ideas?
Thank you. I looked at those too but did not go that route, yet. Guess I had better dive in and do it.
thank you for taking the time to reply. I did the "sounds like" technique. I ended up getting Pizza Hut as a return for Puget and got nothing when the word was Pudget. I figured there would be something more.
Thanks again
As well as the excellent suggestion from @Reeza there are some other ideas here -> https://blogs.sas.com/content/sgf/2015/01/27/how-to-perform-a-fuzzy-match-using-sas-functions/ although having done some fuzzy matching in the past I couldn't guarantee that anything you try will always catch all the potential matches you'd like. You might have to incorporate several of the suggested techniques to get a good coverage.
Thank you. I looked at those too but did not go that route, yet. Guess I had better dive in and do it.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.