topic Re: Programmatically extracting table values for use in a procedure in SAS Programming

Programmatically extracting table values for use in a procedure

nicwoyak — Thu, 20 Feb 2020 17:57:56 GMT

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?

Re: Programmatically extracting table values for use in a procedure

Reeza — Thu, 20 Feb 2020 18:01:23 GMT

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.

Re: Programmatically extracting table values for use in a procedure

Reeza — Thu, 20 Feb 2020 18:02:32 GMT

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.