topic Re: Coordinates for Geo Map in SAS Visual Analytics

Coordinates for Geo Map

sat_lr — Mon, 21 Apr 2014 09:43:23 GMT

Hi All,

I am looking for coordinates for the mentioned address.

The data set has a address column and it contains district names and state names. It is of one column perhaps doesn't have post code.

How to get coordinates as my customer looks for geo map to locate the production units.

Thanks in advance.

regards

Re: Coordinates for Geo Map

MichelleHomes — Mon, 21 Apr 2014 11:20:53 GMT

I'm not sure what address you are referring to and what country you are hoping to geocode.

You might find this SAS Global Forum 2013 paper a good reference to understand geocoding and how to do it using PROC GEOCODE - http://support.sas.com/rnd/papers/sasgf13/Geocode2013.pdf

Re: Coordinates for Geo Map

PeterWijers — Mon, 21 Apr 2014 16:02:10 GMT

I Use a sas script that requests the longitude/latitude off an address string from google maps.

This way I get all my long/latitudes and use these in SAS VA.

If you want to solve it this way, I can sent you the related SAS code. It works well for me this way.

Requesting the Centre country long/lat also helps with drilling down. (Also for geo area)

Greetings.

Re: Coordinates for Geo Map

sat_lr — Mon, 21 Apr 2014 16:44:22 GMT

Yes pls thats would be grt. Thanks Peter.

Pls inbox me.

This thing is that I have already started using the data set and I have produed visualizations, dashboards and explorations. Now I have got a new requirement from the customer to include geo maps.

kindly suggest me how I can run the codes. should I have to create a new SAS data set? will it append as a geo category automatically which is existing in-memory in SAS VA data source?

Re: Coordinates for Geo Map

PeterWijers — Mon, 21 Apr 2014 18:18:28 GMT

Hi sat_Ir,

I will sent the full script to your mail account.

Here for all the other interested users.

The main function in SAS is as follows, but still needs some scripting to get ir right.

%MARCRO Url_get_comp(key, street, zipc, city, country);

%LET Url_address="https://maps.googleapis.com/maps/api/geocode/xml?address=&street,+&zipc,+&city,+&country*sensor=false";

%LET Url_address=%sysfunc(TRANSLATE(&URL_address,'&','*'));

%PUT &Url_address; FILENAME www url &Url_address;

I create a table that contains the non matched addresses and call on the macro by record.

The received log/lat are stored in the address table and sent to the VA server.

This address table in imported into VA via a data querry and ready for use.

Now Change the role of the address field name to Geography and assign the log/lat under custom.

This field will now ackt as a geo location field.

Greetings and succes.

Re: Coordinates for Geo Map

adriana_dominguez — Sun, 01 Jun 2014 04:28:51 GMT

Hi, Peter! How are you?

I have recently been playing with the ggmap library in R to do precisely the discussed here: give long/lat for a dataset where I have specific addresses. I just recently discovered that one can do this with SAS. Could you also share your macro code with me? That would be extremely helpful!

Greetings from Mexico

Re: Coordinates for Geo Map

PeterWijers — Sun, 01 Jun 2014 09:21:12 GMT

Hi Adriana.

of course you can get the full macro code.

Please give me your e-mail and I will sent it to you.

Greetings from Holland.

Re: Coordinates for Geo Map

adriana_dominguez — Sun, 01 Jun 2014 17:17:59 GMT

Thank you!

Re: Coordinates for Geo Map

PeterWijers — Mon, 02 Jun 2014 04:39:44 GMT

Adriane,

the full scruipt has been sent to your e-mail.

Good luck while implementing it.

Greetings.

Re: Coordinates for Geo Map

sat_lr — Wed, 04 Jun 2014 09:51:11 GMT

Hi Peter,

grt info. thanks very much for the reply. I have created the geo map using your script. Thanks.

satlr

Re: Coordinates for Geo Map

PeterWijers — Thu, 05 Jun 2014 17:02:00 GMT

Hi satir,

verry good to hear it works out for you.

Thats what its all about here.

Greetings

Re: Coordinates for Geo Map

bhagia — Tue, 08 Jul 2014 09:27:36 GMT

Hi Peter,

could you please sent that code to me?

Thanks

bhagia

Re: Coordinates for Geo Map

PeterWijers — Wed, 16 Jul 2014 11:59:51 GMT

hello bhagia,

I did sent the full code to you just now.

Good luck with it and greetings.

Peter

Re: Coordinates for Geo Map

Schumann — Thu, 17 Jul 2014 16:25:55 GMT

Hi Peter,

Could you send the full code to me as well?

Thanks,

David

Re: Coordinates for Geo Map

AnnaBrown — Thu, 17 Jul 2014 18:14:09 GMT

Hi Peter,

Thanks so much for sending community members the full code. You may have tried already, but you can "Upload a file" in the "Actions" box in the right nav of the community landing page to post the code in a separate thread (maybe link to this thread for reference). Just a thought rather than sending it individually several times over.

, and I'm so glad this information is helpful. Due to security reasons, I'd like to edit out your email addresses from this thread. Email address harvesting is becoming more common, and posting your address in a public forum like this puts you at risk. I hope you don't mind my taking out your emails.

Schumann, I know you still need the code. Peter, if you're having trouble uploading it through the "upload a file" method, I can direct message you Schumann's email.

Best,

Anna

Re: Coordinates for Geo Map

PeterWijers — Thu, 17 Jul 2014 18:26:36 GMT

Hi Anna,

I agree with you regarding the security issue. (Never thought about it in this way)

Please sent me the last email address so I can sent him the code.

I will try to upload the code as mentioned by you at a later moment.

Greetings Peter.

Re: Coordinates for Geo Map

Jeove74 — Wed, 27 Aug 2014 22:30:00 GMT

Hi Peter,

Can I receive the full code example as well 🙂

Kind regards,

Jesper Bæk Overgaard

Re: Coordinates for Geo Map

FriedEgg — Thu, 28 Aug 2014 00:10:55 GMT

In the absence of PROC GEOCODE, and as already mentioned, an option is to utilize Google's Mapping API for geocoding. I believe you are given a daily grace of about 2,500/day. Here are links to two implementations, one using PROC GROOVY and another using PROC FCMP.

An interface for using Google Geocode API with PROC GROOVY in SAS

Another implementation of using Google geocoding API in SAS, this time using PROC FCMP

Re: Coordinates for Geo Map

PeterWijers — Thu, 28 Aug 2014 05:04:12 GMT

Hello Jesper,

here is the code I sadly forgot to append in the past. (Anna, sorry for that)

greetings and good luck with it.

Re: Coordinates for Geo Map

AnnaBrown — Thu, 28 Aug 2014 13:27:42 GMT

Thanks a bunch, Peter.

Jesper, welcome to the community! FYI, I deleted your email address on this thread for security reasons. I hope you have everything you need with Peter's attached code.

Best,

Anna