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.

 

 

SAS INNOVATE 2024

innovate-wordmarks-white-horiz.png

SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

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