Json Library

harihyd2021 — Fri, 19 Nov 2021 05:45:32 GMT

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.

Re: Json Library

sbxkoenk — Fri, 19 Nov 2021 08:51:03 GMT

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

topic Re: Json Library in SAS Programming

Json Library

Re: Json Library