Hey there,
I have a list of account names and would like to match them however there are punctuation, spaces & other strings that does not. I already, tried TRIM & Compress and my last road blocked is replacing values like INC. to INCORPORATED.
Sample:
ABC Corp = ABC Corporation
A BC Corporation = ABC Corporation
ABC.Corporation = ABC Corporation
Hope you can help me on this.
Thanks,
Pablo
Have you looked at TRANWRD function?
The other option is REGEX
No other short way. Make a dictionary table and contain all these rules together.
What you're after is "standardization". If these are only a few cases like "corp." to "Corporation" then some sort of lookup table approach to translate words could work. If the number of cases is bigger and there could additional ones in the future then software which helps you with standardization would be the optimal way to go. With SAS such standardization "routines" are available via the SAS Data Quality Server ("DataFlux").
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.