Like @SASKiwi explained, it's a tedious task to work through. There is a previous thread that addresses this and even made the same suggestion as @SASKiwi: https://communities.sas.com/t5/SAS-Procedures/Address-cleaning/td-p/521206. The article references a paper found here that may be useful: https://analytics.ncsu.edu/sesug/2008/CC-028.pdf
strip and prxchange functions are going to be your friend.
... View more
