load proc http json results direct into dataset?

[Dwayne-Dibbley]

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

[DaveHorne · Accepted solution]

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).

[ChrisHemedinger]

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.

[Dwayne-Dibbley]

Thanks tweaked the code as per the link

off to the next project 🙂