topic Getting Table from Web into SAS Data Set in SAS Programming

Getting Table from Web into SAS Data Set

A_SAS_Man — Wed, 29 Apr 2020 14:37:37 GMT

I am wondering how to convert a table on a website into a SAS data set. I'm trying to do this on a somewhat regular basis, so I'm trying to find a good way to automate it. The website I'm trying to access is: https://covidtracking.com/data/state/california#historical

The table I'm trying to access is the "History" table.

I realize some parsing is needed, but I seem to be unable to even locate the data in my sas session. When I run the following code I don't get any errors, but I am unable to access the data "src" anywhere as far as I can tell.

filename src temp;
proc http
method="GET"
url="https://covidtracking.com/data/state/california#historical"
out=src;
run;

Re: Getting Table from Web into SAS Data Set

Reeza — Wed, 29 Apr 2020 15:33:06 GMT

https://data.chhs.ca.gov/dataset/california-covid-19-hospital-data-and-case-statistics/resource/6cd8d424-dfaa-4bdd-9410-a3d656e1176e?view_id=b23b0158-a85d-4bf2-95b1-96f7556f7342

What about this source instead? From the open data portal and the API guide is there.

Re: Getting Table from Web into SAS Data Set

AhmedAl_Attar — Wed, 29 Apr 2020 16:03:27 GMT

I think you would be better served by using the json data from the same web site https://covidtracking.com/api.

Based on their api documentation on the same web site, here is how you can California Historical data into a SAS data set

filename resp temp;
 
/* Neat service from Open Notify project */
proc http 
 url="https://covidtracking.com/api/v1/states/CA/daily.json"
 method= "GET"
 out=resp;
run;
 
/* Assign a JSON library to the HTTP response */
libname covid JSON fileref=resp;
 
proc print data=covid.root (drop=ordinal:);
run;

Hope this helps,

Ahmed