topic Re: Get county when doing a proc geocode street level with status = 'Zip match' in SAS Procedures

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

jerry898969 — Tue, 02 Jun 2015 17:34:12 GMT

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.

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

ballardw — Tue, 02 Jun 2015 19:39:36 GMT

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.

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

jerry898969 — Wed, 03 Jun 2015 12:57:46 GMT

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