Accessing API with Proc HTTP and Saving Output

A_SAS_Man — Tue, 11 Jun 2019 21:07:47 GMT

I am attempting to pull data from a public API using proc http. I will eventually want to feed a file with multiple values to the API and collect the response, but for now I am just trying to understand the mechanics of accessing it so I'm using a static URL. I'm having trouble figuring out how to view my output below.

proc http
method="GET"
url="https://rxnav.nlm.nih.gov/REST/ndcstatus?ndc=00093727356/rxnormdata/ndcStatus/allhistoricalndcs"
out=resp;
run;

This appears to run without error, and as I understand it should generate a .json file, but I'm not sure how I can view that/parse it into something useful. I have been getting information on the API from the following source:

https://rxnav.nlm.nih.gov/RxNormAPIs.html#

How can I take my json output (resp) and convert it into a datafile? How can I tell if my call to the API is actually working?

Re: Accessing API with Proc HTTP and Saving Output

Reeza — Tue, 11 Jun 2019 21:21:16 GMT

It looks like the response is XML, not JSON.

filename resp '/home/XXXXXXX/Demo1/demo.xml';

proc http
method="GET"
url="https://rxnav.nlm.nih.gov/REST/ndcstatus?ndc=00093727356/rxnormdata/ndcStatus/allhistoricalndcs"
out=resp;
run;

libname myfiles xml '/home/XXXXXXX/Demo1/demo.xml';

data ndcstatus;
set myfiles.ndcstatus;
run;

proc print;run;

@A_SAS_Man wrote:

I am attempting to pull data from a public API using proc http. I will eventually want to feed a file with multiple values to the API and collect the response, but for now I am just trying to understand the mechanics of accessing it so I'm using a static URL. I'm having trouble figuring out how to view my output below.
proc http
method="GET"
url="https://rxnav.nlm.nih.gov/REST/ndcstatus?ndc=00093727356/rxnormdata/ndcStatus/allhistoricalndcs"
out=resp;
run;
This appears to run without error, and as I understand it should generate a .json file, but I'm not sure how I can view that/parse it into something useful. I have been getting information on the API from the following source:

https://rxnav.nlm.nih.gov/RxNormAPIs.html#

How can I take my json output (resp) and convert it into a datafile? How can I tell if my call to the API is actually working?

topic Re: Accessing API with Proc HTTP and Saving Output in SAS Programming

Accessing API with Proc HTTP and Saving Output

Re: Accessing API with Proc HTTP and Saving Output