01-18-2017 04:55 AM
I would like to create a sas geo map for France country.
I need to populate the longtitude and latitude column in order to create geo map.
Please advise how we can lookup the values for France country based on ZIP code or address details.
01-18-2017 05:18 AM
Maybe we'll need more details about what you're trying to achieve but you can find details about France (or other countries) from the MAPS* libraries you should have access to.
But my understanding is that you want to position points on a map based on an address.
In that case, if you want to use an address to get the coordinates, you will need to get the lookup data (available with SAS9.4 Maintenance 4 for US, canada, UK and australia, not France) and use the GEOCODE procedure.
You may find those 2 articles useful:
01-18-2017 07:44 AM
There are sources of French Postal Codes. For example:
I no nothing about this data nor how up to date it is.
Perhaps you can put it in the format that Proc GEOCODE needs. Look in the second paper mentioned above or in the Doc files on http://support.sas.com/
01-18-2017 08:08 AM
I am very new to Geocode.
If input dataset is in local language how this will impact output result
Could you please share the sas codeing to dervive latitude details. We have sas 9.4 M3 version. all the maps data alredy downloaded.
01-18-2017 08:27 AM
All the example code is here (for this paper):
Look for the title of the paper: PROC GEOCODE: Finding Locations Outside the U.S.
Under that are two links. One for the paper and one for a Zipfile of the examples.
You need to look at MAPSGFK.WORLD_CITIES to see if the city names match. Look at the other columns to see if matches your data (such as MapIDName).
01-18-2017 11:03 AM
Is it failing in Proc GEOCODE? Or something else? What file are you opening that is failing? I don't think it is MAPSGFK.WORLD_CITIES since it isn't UTF8. Is your address data set UTF8?
I think you will need to talk to Tech Support. I suspect that your data set is UTF8 and you need to invoke SAS as a UTF8 session but I do not know how to do that with Enterprise Guide. Tech Support will be able to help you.
01-19-2017 03:04 AM
Yes...I got the error in Proc geocode. Below is my code.....
method = city /* City method */
data = input /* Addresses to geocode */
out = work.geocoded /* Geocoded data set */
lookupcity = mapsgfk.world_cities /* Default world lookup data */
addresscityvar = city /* Req’d. city name */;
Please let me know how we can fix this issue
01-19-2017 07:12 AM