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/
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.