Help using Base SAS procedures

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

Reply
Super Contributor
Posts: 400

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

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

Super Contributor
Posts: 1,636

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

Posted in reply to jerry898969

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

Super Contributor
Posts: 400

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

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

PROC Star
Posts: 7,489

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

Posted in reply to jerry898969

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

Super User
Posts: 5,516

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

Posted in reply to jerry898969

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.

Super Contributor
Posts: 400

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

Posted in reply to Astounding

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

Super Contributor
Posts: 400

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

Posted in reply to 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.

Ask a Question
Discussion stats
  • 6 replies
  • 173 views
  • 3 likes
  • 4 in conversation