Is it possible to get a zip code based on an address within SAS?

[jerry898969]

I have addresses with incorrect zip codes.  I wanted to create an automated process that would take each address and get the correct zip code.  I have over 700 and doing them manually would take a very long time.   Any help would be greatly appreciated.

Thank you

[Linlin]

I don't think it is possible because there are so many common addresses.

[jerry898969]

Hi Linlin,

I agree that that is true but there should be a way to do that and have a flag that says if the address was found or not.  At least that is what I'm hoping there is.

Thank you

[art297]

A couple of sources are mentioned in the post at: location - Zip Code Lookup API? - Stack Overflow

[Astounding]

Perhaps the zip code is correct and the address is wrong??

At any rate, it sounds like an application that Zillow should develop.  I wonder if they're thinking about it.

[jerry898969]

Thank you for your replies I will look at those links and post my results.

I understand the address could be the problem but I have no choice but to try and get zipped based on address if nothing is returned or found then I can investigate those address.

Thank you

[jerry898969]

Thanks again for all the help.  I was able to find a file that had address geocoded and had the postal standardization info which allowed me to track back and get the zip info.  Thank you again for all your help.