Posts

Showing posts from December, 2013

SAS and Bing Maps API

Here is a method for using SAS and Bing Maps:

Signed up for a key on Bing Maps API. Create a basic key and copy it somewhere. I will demonstrate it in the SAS code as [BINGKEY] since I cannot share mine publicly: https://www.bingmapsportal.com/
Use the following code: %let z1=47.64054;
%let z2=-122.12934;
%let BINGKEY=%NRSTR(&key=[BINGKEY]);

filename x url "http://dev.virtualearth.net/REST/v1/Locations/&z1.,&z2.?o=xml&BINGKEY";
filename z "c:\temp\BingMap.xml";

data _null_;
infile x ;
file z ;
input;
put _INFILE_;
run;

Parse the xml that is produced as needed. You can also output it as JSON if you change the word xml in the URL to json.