SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Pulling in Data via API

Reply
Contributor
Posts: 48

Pulling in Data via API

Hi,

 

I have a series of API's that I want to automatically pull into SAS on a daily/weekly basis. The data is in Json format. Please can somebody offer advice on how I would go about doing this from a coding perspective? I've never needed to do this before and hence I'm not quite sure the steps involved. I am using SAS 9.4.

 

Many thanks

Chris

Valued Guide
Posts: 570

Re: Pulling in Data via API

That's a very big question but as a start you could check out Proc HTTP to issue HTTP requests to bring the data into SAS then use the JSON libname engine to convert the JSON into SAS data sets. You'll find some documentation to get you started at these links

 

http://documentation.sas.com/?docsetId=proc&docsetVersion=9.4&docsetTarget=n0t7v16eitluu2n15ffpfeafq...

 

http://support.sas.com/resources/papers/proceedings17/SAS0380-2017.pdf

 

My advice would be to give this a try and post more specific questions if/when you hit a problem.

Ask a Question
Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation