Geocoding Node
NOTE: Beginning July 31, 2023, SAS will no longer support or provide updates the following data packs:
- US Address Verification (USPS)
- North America Postal Level Geocode (includes PhonePlus)
- Canada Address Verification (Canada Post SERP (Software Evaluation and Recognition System) version 2, release 2 (V2R2))
- US Street Level Geocode (except for Loqate geocode data)
Users that want to perform US/Canada address verification and geocode jobs, must migrate to the Loqate data packs listed below, prior to July 31, 2023.
- Loqate US Data
- Loqate Data (includes Canada)
After July 31, 2023, the SAS Data Management Studio jobs that rely on the discontinued data packs fail and you will receive license errors. See the SAS Data Management Studio and Server 2.9: Migration Guide for Data Packs for additional information.
You can add a Geocoding node to a data job to match geographic information from the geocode reference database with ZIP codes in your data to determine latitude, longitude, census tract, Federal Information Processing Standards (FIPS), and block information.
To use Geocoding, you must have ZIP or ZIP+4 code values in your address data for US geocoding and full post codes for Canadian address geocoding (or be able to create them using the Address Verification (US/Canada) node). A US 5-digit ZIP code will return only the longitude and latitude. A US ZIP+4 additionally provides the other Geocoding outputs. Results from Geocoding processing are placed in fields named as specified in the Geocoding Properties window.
Once you have added the Geocoding node, you can double-click it to open its properties window. The properties window includes the following elements:
Name - Specifies a name for the node.
Notes - Enables you to open the Notes window. You use the window to enter optional details or any other relevant information for the input.
Input - Displays all of the fields on which you can run geocoding. Items in this list are dependent on your data source(s) and any steps preceding the Geocoding node in your data job. To implement geocode processing, click in the field that contains your ZIP code values. Then, select Postal/ZIP from the drop-down menu in the Field Type column (for mixed United States/non-United States data or purely non-United States data) or ZIP+4 (for US only data). If a field contains both the ZIP and ZIP+4 data in the same column, select Postal/ZIP as the type.
The Output fields section of the window includes the following elements:
Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.
Selected - Displays the fields that will be made available to the next node in your data job.
Additional Outputs - Displays the Additional Outputs window. This window enables you to specify the fields that you can make available to the next node in your data job.
You can access the following advanced properties by right-clicking the Geocode node: