BookmarkSubscribeRSS Feed
LOLO12
Obsidian | Level 7

I'm trying to import data from this site 

https://polygon.io/docs/stocks/getting-started

 

by SAS viya or SAS Window. 

I have tried few codes and was not successful. 

5 REPLIES 5
Reeza
Super User
Please include any code you've tried.

Assuming you're doing something like this: https://blogs.sas.com/content/sasdummy/2018/01/16/hide-rest-api-tokens/

ChrisHemedinger
Community Manager

I signed up for an API key (free) so I could try this. In SAS it's straightforward. Here's my code using their sample call:

 

 

filename resp temp;

proc http
 url="https://api.polygon.io/v2/aggs/ticker/AAPL/range/1/day/2021-07-22/2021-07-22?adjusted=true&sort=asc&limit=120"
 out=resp
 oauth_bearer="your-api-key";
run;

libname data json fileref=resp;
proc print data=data.results;
run;
 

 

Output:

ChrisHemedinger_0-1645971976092.png

Instead of the OAUTH_BEARER option (shorthand for the OAuth pattern), you can also use the HEADERS statement:

 

proc http
 url="api-call"
 out=resp;
 headers 
  "Authorization" = "Bearer your-auth-key";
run;

 

 

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
LOLO12
Obsidian | Level 7

I tried this code and still not working 

 

proc http
url="https://api.polygon.io/v2/aggs/ticker/AAPL/range/1/day/2021-07-22/2021-07-22?adjusted=true&sort=asc&..."
out=resp;
headers
"Authorization" = "Bearer <token>";
run;

 

 

mona12_0-1646245176168.png

 

Reeza
Super User

Delete your token from the message.

ChrisHemedinger
Community Manager

Can you make any PROC HTTP calls to the internet in SAS? Try the steps in this blog post. You might need to specify a proxy host.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1827 views
  • 2 likes
  • 3 in conversation