text mining for address match

SASPhile — Wed, 03 Nov 2010 19:37:46 GMT

I'm wondering if there is any text mining technique that is used to mtach the address fields based on phyid.
for instance:
Phyid adr1 phyadr1
010011829 501 MED CENT DR 501 MEDICAL CENTER DR BOX 30114
010011829 501 MED CENTER DR STE:300 501 MEDICAL CENTER DR BOX 30114

adr1 and phyadr1 are the same.but this is how the data is provided.
how to match adr1 and phyadr1 in such cases?

Re: text mining for address match

Daryl — Thu, 04 Nov 2010 14:28:59 GMT

Does your site license the SAS Data Quality Server? This gives you procedures and data step functions that allow fuzzy matching for text data such as names and addresses.

If you don't have a license for the data quality tools, you would need a way to parse the addresses into components (house number, street name, box number, suite number, etc.), standardize these elements, and then order them to create appropriate groups that represent the same location.

about DQ Server: http://support.sas.com/documentation/cdl/en/dqclref/63101/HTML/default/viewer.htm#a003359998.htm

about PROC DQMATCH:
http://support.sas.com/documentation/cdl/en/dqclref/63101/HTML/default/viewer.htm#a002629014.htm

topic text mining for address match in SAS Programming

text mining for address match

Re: text mining for address match