Solved: zipcitydistance not working for some zip codes

Akhila1 · Posted 10-06-2022 02:04 PM

Hello,

zipcitydistance is not working for the following zip codes

distance =zipcitydistance (zip_,76019)

ZIP_

75072

75036

76025

76100

ballardw · Posted 10-06-2022 03:10 PM

Usually that means that the Zip code is not in the SASHELP.ZIPCODE data set. It may be that yours is out of date. Instructions on updating it are here:

https://support.sas.com/techsup/notes/v8/19/861.html

or that those Zip codes do not exist

When I use the US Post office Zip code to identify the city from zip at https://tools.usps.com/zip-code-lookup.htm?citybyzipcode

The 76025 and 76100 return as invalid Zip codes.

View solution in original post

ballardw · Posted 10-06-2022 03:10 PM

Usually that means that the Zip code is not in the SASHELP.ZIPCODE data set. It may be that yours is out of date. Instructions on updating it are here:

https://support.sas.com/techsup/notes/v8/19/861.html

or that those Zip codes do not exist

When I use the US Post office Zip code to identify the city from zip at https://tools.usps.com/zip-code-lookup.htm?citybyzipcode

The 76025 and 76100 return as invalid Zip codes.