Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Super Contributor
Posts: 398
Accepted Solution

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

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.


Accepted Solutions
Solution
‎06-02-2015 03:39 PM
Super User
Posts: 10,483

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

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.

View solution in original post


All Replies
Solution
‎06-02-2015 03:39 PM
Super User
Posts: 10,483

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

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.

Super Contributor
Posts: 398

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

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

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