topic Re: How do I search a string for a specific name even if the string is misspelled in SAS Programming

How do I search a string for a specific name even if the string is misspelled

Lorna — Thu, 11 Apr 2019 22:28:53 GMT

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?

Re: How do I search a string for a specific name even if the string is misspelled

Reeza — Thu, 11 Apr 2019 22:44:58 GMT

SOUNDS LIKE.
http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#p0a62rd151ctown1x38ihdpjozyv.htm

Re: How do I search a string for a specific name even if the string is misspelled

ChrisBrooks — Thu, 11 Apr 2019 23:36:37 GMT

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.

Re: How do I search a string for a specific name even if the string is misspelled

Lorna — Fri, 12 Apr 2019 13:38:10 GMT

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

Re: How do I search a string for a specific name even if the string is misspelled

Lorna — Fri, 12 Apr 2019 13:41:32 GMT

Thank you. I looked at those too but did not go that route, yet. Guess I had better dive in and do it.