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
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.
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.