BookmarkSubscribeRSS Feed
SASAccDave
Calcite | Level 5

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!

1 REPLY 1
SASAccDave
Calcite | Level 5
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
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 1 reply
  • 554 views
  • 0 likes
  • 1 in conversation