topic Re: Web Services With SAS in SAS Programming

Web Services With SAS

Danitin — Thu, 12 Sep 2019 15:45:34 GMT

I am trying to learn about web services in SAS, and then i found this paper: https://support.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/1937-2018.pdf
But when i try tu run the first sample code it return a few erros:

30 libname jout JSON fileref="resp";
ERROR: The JSON engine cannot be found.
ERROR: Error in the LIBNAME statement.
31
32 proc print data=jout.NEAR_EARTH_OBJECTS__018_01_02;
ERROR: Libref JOUT is not assigned.
33 run;

The code is:

filename resp temp;
proc http url="http://www.neowsapp.com/rest/v1/feed/today"
out=resp
method="GET";
run;
libname jout JSON fileref="resp";
proc print data=jout.NEAR_EARTH_OBJECTS__018_01_02
run;

Can someone tell what is whrong on it?

Re: Web Services With SAS

ChrisNZ — Thu, 12 Sep 2019 21:59:50 GMT

My version of SAS is too old to know about JSON, but your code looks wrong.

Try:

libname jout JSON fileref=resp;

Quotes are needed for physical names, and logical names are not quoted.

Re: Web Services With SAS

AnandVyas — Fri, 13 Sep 2019 03:27:36 GMT

Hi @Danitin ,

SAS Installed at your site should be 9.4 M4, 64-bit in order to use JSON libname engine.

Thanks!