Json Library

[harihyd2021]

Hi All,

I am fetch the data using Rest API using SAS Studio. Data is  coming but it is storing in one column Table under RESPOSE JSON COLUMN NAME  . So, how fetch the data from that column.

[sbxkoenk]

Hello,

I think this paper will help you out :

Paper 856-2017
Parsing JSON with SAS® in 2017
John Kennedy, Mesa Digital
https://support.sas.com/resources/papers/proceedings17/0856-2017.pdf

How to make JSON response file available within SAS (numeric and string data in a SAS data set)? :

USING THE JSON LIBNAME

The JSON libname is the newest, sexiest, and easiest way to import JSON data into SAS. It handles the parsing of the data, can account for a variable data structure, and can be combined with other procedures to increase its functionality.

filename response temp;

proc http  

  url="http://data.ny.gov/api/views/kwxv-fwze/rows.json?accessType=DOWNLOAD"

  method= "GET"

  out=response;

run;

libname lotto JSON fileref=response;

proc print data=lotto.data;

run;

Koen