Get county when doing a proc geocode street level with status = 'Zip match'

[jerry898969]

Hello,

I'm trying to get a fips county code back when the _status_ is equal to 'Zip match'.  Currently it returns a missing value for those rows.

Is this possible to do with SAS 9.4 64-bit (TS1M2)?

Here is my code

proc geocode
method = street
addressvar = R_ADDR
addresscityvar = R_CITY
addressstatevar = R_ST
addresszipvar = R_ZIP
data = address
out = address_out
attribute_var = (COUNTYFP, TRACT, BLKGRP, BLOCK)
FIPS=SASHELP.PLFIPS
lookupstreet = geodata.USM
;
run ;

Thank you for any help you can give me.

[ballardw · Accepted solution]

This looks an awful lot like the previous question: https://communities.sas.com/message/274254#274254

Does the geodata.usm dataset have a county FIPS code for every Zipcode?

If not you could merge the one from the SASHELP.ZIPCODE data set.

[jerry898969]

Ballardw,

I'm sorry about that.  This was about SAS 9.4 the other was with 9.3.  I have to use latitude and longitude to get the it to work.  I used this information to get the county fips code where it was missing from the geocode process.

SAS/GRAPH(R) 9.2: Reference, Second Edition

Thank you