BookmarkSubscribeRSS Feed
jerry898969
Pyrite | Level 9

I'm using proc geocode to geocode many addresses.  I have one example where the address says it's a street and zip match, but the M_ADDR value is nothing like the address passed in.  I get a score of 15 for that geocode.  In this case I can't use this data because the X Y values point to the matched address not the original address passed in.  What score or what way can I avoid using the incorrect matched address values?

 

Here is my geocode:

proc geocode
method = street
addressvar = r_addr
addresscityvar = r_city
addressstatevar = r_state
addresszipvar = r_zip
data = addr_raw
out = addr_geocoded
attribute_var = (COUNTYFP, TRACT, BLKGRP, BLOCK)
lookupstreet = geodata.USM
;
run ;
2 REPLIES 2
ballardw
Super User

All I can suggest is to examine your data and that result very carefully (Google Map or similar may be helpful). I do know that when I went to close on the purchase of my house that we had different records for the property with three different addresses depending on the source. If it is a corner lot you may be getting the address from an intersecting street.

 

 

jerry898969
Pyrite | Level 9

ballardw,

 

Thank you for your reply.   Is there a way with proc geocode to make the match exact or just slightly different?

 

This process will need to run for over 80K obserevations and I have to make sure the latitude and longitude point to the original address.

 

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1045 views
  • 0 likes
  • 2 in conversation