DATA Step, Macro, Functions and more

Standardizing Addresses

Reply
Contributor
Posts: 32

Standardizing Addresses

I have property data sets with about 600,000 observations. I have variables for owner address-city-state-zip and variables for physical address-city-zip. I created a variable to indicate whether the owner address variable matches the physical address, but the lack of standardization in the data sets disrupts the accuracy of the matching (e.g. 3rd St. doesn't match with 3rd Street, or 3rd St. doesn't match with Third St.). What is the best way to standardize addresses in SAS? Is that even doable?

PROC Star
Posts: 549

Re: Standardizing Addresses

Posted in reply to andrewfau

This often better done in data profiling tools like Dataflux.

 

I have worked on address standardization but mostly through the hand written code. I used to do this on basis of business rules defined by stakeholders(regularly new rules were defined, say once in couple of months), it solved most of our problems but  was not enough ( this is what I strongly believe). 

 

When I was in this project they allow me to use Dataflux, because I was told that running Dataflux on large datasets will take lot of time. I was using datasets close to 200 million records and was using explicit SQL pass through.

 

Below is paper on Dataflux, which you might find interesting

 

http://www2.sas.com/proceedings/sugi30/102-30.pdf

Ask a Question
Discussion stats
  • 1 reply
  • 205 views
  • 1 like
  • 2 in conversation