BookmarkSubscribeRSS Feed
arpitagarwal512
Calcite | Level 5

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.

5 REPLIES 5
Reeza
Super User

JSON libname is available as of SAS 9.4 TS1M4

 

Whicj version do you have installed?

arpitagarwal512
Calcite | Level 5

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

 

 

Reeza
Super User

That's M3 unfortunately, not M4. 

arpitagarwal512
Calcite | Level 5

Hi Reeza,

 

Is there any workarround to do this task in current machine

Reeza
Super User

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/

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1546 views
  • 0 likes
  • 2 in conversation