topic Account Name Clean Up - Fuzzy Look Up in SAS Enterprise Guide

Account Name Clean Up - Fuzzy Look Up

pgdelafuente — Thu, 16 Apr 2015 03:35:05 GMT

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

Re: Account Name Clean Up - Fuzzy Look Up

Reeza — Thu, 16 Apr 2015 03:51:03 GMT

Have you looked at TRANWRD function?

The other option is REGEX

Re: Account Name Clean Up - Fuzzy Look Up

Ksharp — Thu, 16 Apr 2015 12:44:25 GMT

No other short way. Make a dictionary table and contain all these rules together.

Re: Account Name Clean Up - Fuzzy Look Up

Patrick — Thu, 16 Apr 2015 12:55:11 GMT

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").