I'll ask again.
Have you looked at the spelling distance functions? like SPEDIS or COMPGED?
To build on @ChrisNZ's suggestion, check out this fuzzy matching tip from @Ron_Cody:
https://blogs.sas.com/content/sastraining/sas-authors-tip-spedis-and-fuzzy-matching/
Yes, they both are giving me the desired output.
I tried where soundex(a.text)=soundex(b.text), this did not yeild the result as well. Many of the words between the two strings match. Yet soundex fails.
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.
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.