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.
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.
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.