An Idea Exchange for SAS software and services

Comments
by Trusted Advisor
on ‎01-08-2015 11:59 AM

I would like to see XML and JSON objects in PROC DS2 especially since the release of the HTTP package to process response streams.

by New Contributor ATT
on ‎09-22-2016 11:36 AM

The enhancements in 9.4 M3 are great to see but it would be great to see this feature available via a GUI. Other tools are making strong progress in this area:

https://www.domo.com/product/connectors

https://www.tableau.com/about/blog/2016/8/tableau-101-beta-here-58447

 

 

by Community Manager
on ‎12-07-2016 08:44 AM
Status changed to: Implemented

The ability to read/parse JSON as data is now in SAS 9.4 Maint 4.  See:

Simple example:

 

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;

Output:

 

Who is in space right now? (as of 07DEC16)

     Obs    craft          name

       1     ISS     Sergey Rizhikov 
       2     ISS     Andrey Borisenko
       3     ISS     Shane Kimbrough 
       4     ISS     Oleg Novitskiy  
       5     ISS     Thomas Pesquet  
       6     ISS     Peggy Whitson   

 

Marking this as Delivered.

Idea Statuses
Top Liked Authors