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.
JSON libname is available as of SAS 9.4 TS1M4
Whicj version do you have installed?
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
That's M3 unfortunately, not M4.
Hi Reeza,
Is there any workarround to do this task in current machine
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/
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.