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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.