SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
nicwoyak
Obsidian | Level 7

I am using proc http to make a call to Google's Distance Matrix API. The requests for this are of the format: url="https://maps.googleapis.com/maps/api/distancematrix/ json?units=imperial &origins=lat1,long1|lat2,long2|...|latn,longn&destinations=lat1,long1|lat2,long2|...|latn,longn &key=<API_Key >". I have a table that contains lat longs and I would like to programmatically take those values from their column and put them into the format necessary to make the API call. What are some approaches that might work for this?

2 REPLIES 2
Reeza
Super User
Basic data step, this paper covers it in detail with their full code examples of how they did it.

https://www.lexjansen.com/mwsug/2016/BI/MWSUG-2016-BI02.pdf

You'll likely also want a macro of sorts to handle each call and store the output but not sure of the exact details of how this works anymore.
Reeza
Super User
I should say, it illustrates the approach. They're using addresses and you're using lat/long which changes the parameters but not the general idea.

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 671 views
  • 0 likes
  • 2 in conversation