topic Re: load proc http json results direct into dataset? in SAS Programming

load proc http json results direct into dataset?

Dwayne-Dibbley — Fri, 04 Jan 2019 10:56:17 GMT

Hi,

I have the following code:

options NOQUOTELENMAX;

filename usage "/folders/myfolders/sasuser.v94/usage.json";

%let AccessKey = reallylongstring;
	
proc http
 url="https://a.url"
 method="GET" out=usage;
 headers 
   "Authorization"="Bearer &AccessKey.";
run;

libname usage json "/folders/myfolders/sasuser.v94/usage.json";

data usage;
 set usage.data;
run;

proc print data=usage noobs;
run;

is it possible from the proc http to load the json data into the dataset instead of populating a file then loading the dataset from the file?

Thanks

Re: load proc http json results direct into dataset?

DaveHorne — Fri, 04 Jan 2019 16:11:31 GMT

Hi @Dwayne-Dibbley, it's very doable. Check out the blog post from @ChrisHemedinger:

https://blogs.sas.com/content/sasdummy/2016/12/02/json-libname-engine-sas/

(I like the "Who is in space right now" example).

Re: load proc http json results direct into dataset?

ChrisHemedinger — Fri, 04 Jan 2019 16:19:41 GMT

Actually @Dwayne-Dibbley, assuming that the code you shared is working for you, that's exactly how you do it. The JSON response comes back as a file, and then you use the JSON LIBNAME engine to read it. It might (logically) contain several data sets that relate to each other, so this additional step is needed for SAS to interpret the data as you need it.

Re: load proc http json results direct into dataset?

Dwayne-Dibbley — Fri, 11 Jan 2019 09:04:35 GMT

Thanks tweaked the code as per the link

off to the next project 🙂