- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 02-20-2020 12:01 PM
(670 views)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.