When you use ZIP+4 geocoding,
you must specify an alternative lookup data set because SASHELP.ZIPCODE
does not contain any ZIP+4 values. This data set must contain the
following variables:
Four-digit ZIP+4 extension
Longitude of the central
coordinate
Latitude of the central
coordinate
You can specify different
names for the variables by using options in the PROC GEOCODE statement.
For example, the LOOKUPPLUS4 option specifies the name of the ZIP+4
extension variable in the lookup data set.
The ZIP and PLUS4 variables
can contain either character data or numeric data. The data type must
match the type of the corresponding variable in your input data set.
Note: The character values in your
input and lookup data sets do not need to be a case-sensitive match.
Character value matching in the GEOCODE procedure is not case sensitive.
Additional non-geocoding
attribute variables can also be in the alternate lookup data set.
You can add these variables to the output data set by using the ATTRIBUTEVAR=
option in the PROC GEOCODE statement.
You can obtain a lookup
data set for ZIP+4 geocoding from the SAS Maps Online Web site at
www.sas.com/mapsonline
.
On the
Downloads page, select
Geocoding to
access the downloads that are related to geocoding.
An alternative source
for ZIP+4 lookup data is the Geo*Data product from Melissa Data. You
can use the %GCDMEL9 autocall macro to convert Geo*Data files to SAS
data sets.
For more information,
see %GCDMEL9 Autocall Macro.