Programmatically extracting table values for use in a procedure

[nicwoyak]

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?

[Reeza]

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]

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.