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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: