An Idea Exchange for SAS software and services

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:



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 
 method= "GET"
/* 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:);



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