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
I don't think it is possible because there are so many common addresses.
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
A couple of sources are mentioned in the post at: location - Zip Code Lookup API? - Stack Overflow
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.
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.