topic Re: About GEO MAP in Graphics Programming

About GEO MAP

japsas100 — Wed, 18 Jan 2017 09:55:42 GMT

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.

Re: About GEO MAP

Damo — Wed, 18 Jan 2017 10:18:20 GMT

Hi,

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:

PROC GEOCODE: Now with Street-Level Geocoding

PROC GEOCODE: Finding Locations Outside the U.S.

Cheers,

Damo

Re: About GEO MAP

japsas100 — Wed, 18 Jan 2017 12:44:05 GMT

Thnaks Damo,

If we have only City and address column then how to derived the longitude and latitude details with Proc Geocode.

City and address have in local language.

Please advise.

Re: About GEO MAP

Darrell_sas — Wed, 18 Jan 2017 12:44:13 GMT

There are sources of French Postal Codes. For example:

https://www.aggdata.com/free/france-postal-codes

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/

Re: About GEO MAP

Darrell_sas — Wed, 18 Jan 2017 12:49:14 GMT

If you have the city and want to do a City geocoding, look at the second paper that is mentioned above. There is a world geocoding lookup for cities.

Re: About GEO MAP

japsas100 — Wed, 18 Jan 2017 12:56:35 GMT

If we have only City and address column then how to derived the longitude and latitude details with Proc Geocode.

City and address have in local language.

Please advise.

Re: About GEO MAP

japsas100 — Wed, 18 Jan 2017 13:08:01 GMT

I am very new to Geocode.

If input dataset is in local language how this will impact output result

and

Could you please share the sas codeing to dervive latitude details. We have sas 9.4 M3 version. all the maps data alredy downloaded.

Re: About GEO MAP

Darrell_sas — Wed, 18 Jan 2017 13:27:33 GMT

All the example code is here (for this paper):

http://support.sas.com/rnd/papers/#2013

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).

Re: About GEO MAP

japsas100 — Wed, 18 Jan 2017 14:17:06 GMT

When I submit the sas code its throw error like....'Failed to transcode data from U_UTF8_CE to U_LATIN9_CE' I am running Enterprise Guide.

Re: About GEO MAP

Darrell_sas — Wed, 18 Jan 2017 16:03:51 GMT

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.

Re: About GEO MAP

japsas100 — Thu, 19 Jan 2017 08:04:48 GMT

Yes...I got the error in Proc geocode. Below is my code.....

data input;
input city$;
datalines;
Paris
;
run;

proc geocode
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 */;
run;

Please let me know how we can fix this issue

Re: About GEO MAP

japsas100 — Thu, 19 Jan 2017 11:20:04 GMT

any update on above?

Re: About GEO MAP

Damo — Thu, 19 Jan 2017 12:12:12 GMT

Hi,

As mentioned by @Darrell_sas previously, you may want to contact Technical Support in order to troubleshoot the issue related to the encoding error.

Details are available from https://support.sas.com/techsup/contact/

Cheers,
Damo

Re: About GEO MAP

japsas100 — Thu, 19 Jan 2017 12:32:45 GMT

Thanks