Hello everyone,
Thanks for replying. I work for a college in New Mexico and I want to use addresses to create maps about our students. I need to geocode street addresses so we can visualize different patterns (dot density of different GPAs, etc). I eventually want to geocode for the whole country so we can see where all our students are coming from. Plus we have lots of online courses available, so it would be interesting to see where those students are.
I was trying to use the geocode built into ArcGIS, World Geocode Service, by right clicking on my table with regular street addresses. That's when the "Not Authorized" error occurred. I called ESRI and they told me that this service is no longer available for free, that you have to either make your own geocode or pay for the geocoding services through their new credit system.
After this I tried to create my own geocoder but the data I downloaded off the USDA website only had the street name available, none of the other attribute fields are useful for geocoding. This data didn't work of course because my addresses have the number before the street name. If it had worked I would just download all the other states, but there is no house number range in the attribute table.
Also, my excel table with the student addresses needs formatting. Is SAS a good way to format tables for geocoding? I need to remove the students from the table with null values for their address and some students have the 4digit extension attached to their zip code. I started to go through the data manually, before deciding that was an absolutely ridiculous idea since we have thousands of students.
I'm a beginner at SAS, so any advice about using SAS to create data for ArcGIS would be very helpful.
Thank you,
Renee