topic Re: rest json data parsing in SAS Programming

rest json data parsing

arpitagarwal512 — Thu, 25 May 2017 12:23:53 GMT

Hello Guys,

I am running the below process where i am getting error:

filename resp temp;

/* Neat service from Open Notify project */
proc http
url="http://api.open-notify.org/astros.json"
method= "GET"
out=resp;
run;

/* Assign a JSON library to the HTTP response */
libname space JSON fileref=resp;

/* Print result, dropping automatic ordinal metadata */
title "Who is in space right now? (as of &sysdate)";
proc print data=space.people (drop=ordinal:);
run;

here is below error message i am getting:

32 /* Assign a JSON library to the HTTP response */
33 libname space JSON fileref=resp;
ERROR: The JSON engine cannot be found.
ERROR: Error in the LIBNAME statement.

Re: rest json data parsing

Reeza — Thu, 25 May 2017 12:36:04 GMT

JSON libname is available as of SAS 9.4 TS1M4

Whicj version do you have installed?

Re: rest json data parsing

arpitagarwal512 — Thu, 25 May 2017 12:39:58 GMT

I have run the below code on my sas EG

proc setinit noalias;
run;

Here is the information:

Original site validation data
Current version: 9.04.01M3P062415

Re: rest json data parsing

Reeza — Thu, 25 May 2017 13:25:33 GMT

That's M3 unfortunately, not M4.

Re: rest json data parsing

arpitagarwal512 — Thu, 25 May 2017 14:59:02 GMT

Hi Reeza,

Is there any workarround to do this task in current machine

Re: rest json data parsing

Reeza — Thu, 25 May 2017 15:28:41 GMT

Not easily. You can get the JSON file but need to manually parse it.

I believe PROC GROOVY can help with this.

Or there's a new package in DS2.

The options are illustrated here:

http://blogs.sas.com/content/sasdummy/2015/09/28/parse-json-from-sas/