In my last post, I detailed how to obtain 9 digit zip codes and their X and Y coordinates from a table available from the SAS support site. I passed this information along to the customer in question and he was able to merge in the 9 digit zip information into his table. His next question regarded obtaining the city and state information corresponding to these 9 digit zips.
I did a little digging online and found a graphic that showed the 5 digit zip prefixes for various states followed a predictable pattern.
Next, I found a table on Wikipedia that contained state names, cities and zip code prefixes and figured out how to join it to the 9 digit zip table I created in my last post.
In JMP, you can do the following to add City and State info to any table containing 5 digit zips:
I used the steps above to add city and state info into my ZIP4 data table containing the 9 digit zip codes I imported from the SAS support site and graphed the X and Y coordinates:
(here you go Byron! )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.