How to automate reading .htmls in a csv

SASAccDave — Thu, 10 Sep 2020 17:46:54 GMT

Hello, i currently have a SAS datafile which contains a list of hyperlinks (html).

I have written the following code to find the keyword (".htm") within the hyperlink to get me back some items that i need.

filename proxy url "https://www.sec.gov/Archives/edgar/data/863520/0001193125-19-262939-index.htm";
data proxy_archive(keep=htm);
length htm $200;
infile proxy length = len lrecl = 32767;
input line $varying32767. len;

if find(line, ".htm") then do;
htm = scan(line,-1,'"');
output;
end;
run;
filename proxy clear;

However, the above code only does this for one hyperlink that i manually put into proxy url "..."

I have a list of urls through which i would like to conduct the above code.

Is there a way to do this?

Thank you very much in advance for your help!

Re: How to automate reading .htmls in a csv

SASAccDave — Thu, 10 Sep 2020 17:48:12 GMT

To clarify, i have a list of urls in a SAS datafile in a single column that is also available in a csv format as well