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.
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:
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;
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;
Delete your token from the message.
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.
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 25. Read more here about why you should contribute and what is in it for you!
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.