BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jerry898969
Pyrite | Level 9

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.

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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

2 REPLIES 2
ballardw
Super User

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
Pyrite | Level 9

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 1432 views
  • 0 likes
  • 2 in conversation