US City/State/Zip Validation 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 US City/State/Zip Validation node to a data job to verify that a city and state are correct for the ZIP code provided in the data input. Once you have added the 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.
The Input fields section of the window includes the following elements:
City - Enables you to select a field that contains city data from the drop-down menu.
State - Enables you to select a field that contains state data from the drop-down menu.
Zip - Enables you to select a field that contains ZIP, ZIP Code, or Postal Code data from the drop-down menu.
The Output fields section of the window includes the following elements:
Validation Result - Displays the true or false status of the City/State/ZIP combination. If it is true, it is a valid combination. If the result is false, it is not a valid combination.
Validation Status - When selected, displays the validation status of the Valid, City/State/combination. The Validation Status field is optional.
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 US City/State/Zip Validation node: