https://communities.sas.com/t5/SAS-Procedures/Is-there-a-way-to-conveniently-download-web-files-triggerable-by/m-p/703071#M79919 <P>If you know exact URL for the file you can do it like this:</P> <PRE><CODE class=" language-sas">filename in URL 'https://covid.cdc.gov/XXXXXXXXX/united_states_covid19_cases_and_deaths_by_state.csv' lrecl=1 recfm=n; filename out "%sysfunc(pathname(work))/united_states_covid19_cases_and_deaths_by_state.csv" lrecl=1 recfm=n; data _null_; rc = fcopy('in', 'out'); if rc then put "Error: " rc=; run; filename in clear; filename out clear;</CODE></PRE> <P>B</P> Wed, 02 Dec 2020 11:52:28 GMT yabwon 2020-12-02T11:52:28Z https://communities.sas.com/t5/SAS-Procedures/Is-there-a-way-to-conveniently-download-web-files-triggerable-by/m-p/703026#M79918 <DIV class="lotusFrame lotusui30_layout"><DIV class="lotusMain"><DIV class="lotusContent"><DIV class="lotusLimit"><DIV class="lotusForum "><DIV class="lotusPagedContent"><DIV class="forumQuestion"><DIV><DIV class="hentry lotusPost forumNotResolvedQuestion"><DIV class="lotusPostContent"><DIV class="entry-content lotusPostDetails"><P>Many of our users are doing a lot of weekly and daily updates on some publicly available contents, a good example here would be the 7 days&nbsp;COVID cases that is retrievable here at:&nbsp;<A href="https://covid.cdc.gov/covid-data-tracker/#cases_casesper100klast7days." target="_blank" rel="noopener">https://covid.cdc.gov/covid-data-tracker/#cases_casesper100klast7days.</A>&nbsp;</P><P>&nbsp;</P><P>My question is really an intuitive one: instead of having human interference and manually clicking that 'download' button each time to get the latest case numbers as a .csv file, is there a way to download the file using some kind of SAS procedure?</P><P>&nbsp;</P><P>While my SAS and HTML knowledge is limited, I have tried a few things such as PROC HTTP, but the webpage seems to be using some level of javascript and therefore the static methods which I researched turned out to be not as useful as they should be otherwise.</P><P>&nbsp;</P><P>From my own experience I've utilized web scrapping tools available with python or r to handle an interactive webpage like this, but now SAS is the only tool I am having access to, which ultimately brought me to here to seek some advices on this technical&nbsp;miscellany. Many thanks to anyone who could leave their thoughts!</P></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV> Wed, 02 Dec 2020 08:41:45 GMT https://communities.sas.com/t5/SAS-Procedures/Is-there-a-way-to-conveniently-download-web-files-triggerable-by/m-p/703026#M79918 avinashginjupal 2020-12-02T08:41:45Z https://communities.sas.com/t5/SAS-Procedures/Is-there-a-way-to-conveniently-download-web-files-triggerable-by/m-p/703071#M79919 <P>If you know exact URL for the file you can do it like this:</P> <PRE><CODE class=" language-sas">filename in URL 'https://covid.cdc.gov/XXXXXXXXX/united_states_covid19_cases_and_deaths_by_state.csv' lrecl=1 recfm=n; filename out "%sysfunc(pathname(work))/united_states_covid19_cases_and_deaths_by_state.csv" lrecl=1 recfm=n; data _null_; rc = fcopy('in', 'out'); if rc then put "Error: " rc=; run; filename in clear; filename out clear;</CODE></PRE> <P>B</P> Wed, 02 Dec 2020 11:52:28 GMT https://communities.sas.com/t5/SAS-Procedures/Is-there-a-way-to-conveniently-download-web-files-triggerable-by/m-p/703071#M79919 yabwon 2020-12-02T11:52:28Z