accessing files on the internet

robm — Tue, 18 Feb 2014 02:16:54 GMT

I have a series of html files I need to parse they are of the form: http://shakespeare.mit.edu//full.html where each directory has a html file called full.html ....how can I iterate through and read these files?

Re: accessing files on the internet

Reeza — Tue, 18 Feb 2014 03:43:25 GMT

Bad link, but you can look into PROC HTTP for starters.

Re: accessing files on the internet

robm — Tue, 18 Feb 2014 03:51:45 GMT

here is an example http://shakespeare.mit.edu/comedy_errors/full.html

Re: accessing files on the internet

Cynthia_sas — Tue, 18 Feb 2014 03:57:44 GMT

Hi:

I get a 404 Page Not Found when I try your URL. I think it's wrong anyway, because I don't think a URL can have double // in anyplace except after the http://, but even if I try this: http://shakespeare.mit.edu/full.html it doesn't work.

However, if I go down to the page for All's Well that End's Well at this URL (http://shakespeare.mit.edu/allswell/allswell.1.1.html), I can read the HTML file with the URL engine, however, what comes back is just the HTML on the page (all the tags and text), as you can see in the screen shot of my output window. It would be up to you to write a program to parse the tags, if, for example, you wanted to identify the speeches or make a list of characters.

The index.html file for the site, has the list of files that you can link to, but you would have to get to each of these directories to further grab the HTML on each site. This is shown below in the section of code that reads the INDEX.HTML file for the ALLSWELL subdirectory on the site.

I suppose you could automate everything and iterate with a SAS Macro program, but you first have to get everything working for 1 play before you can automate this for all the plays. And I'm not sure the point of just READING the full HTML of a Shakespeare play with SAS. What is the end result you are looking for??

Cynthia

** go to main index.html page;
filename main url 'http://shakespeare.mit.edu/index.html'
         url debug;

ods _all_ close;
title 'INDEX.HTML for Shakespeare site';
ods listing;
   data _null_;
     infile main;
     file print;
     input;
     put _infile_;
   run;

** read index.html to find how the plays are organized;
** every play has a separate index.html file in a separate directory;
filename alltop url
   'http://shakespeare.mit.edu/allswell/index.html'
debug;

title 'INDEX.HTML for Allswell play';
ods listing;
   data _null_;
     infile alltop;
     file print;
     input;
     put _infile_;
   run;

** read the first section of the Alls Well that Ends Well site;
filename allswell url
   'http://shakespeare.mit.edu/allswell/allswell.1.1.html'
debug;

title 'Alls Well that Ends Well section 1.1';
ods _all_ close;
ods listing;
   data _null_;
     infile allswell;
     file print;
     input;
     put _infile_;
   run;

** or read the FULL play;

filename allsfull url

'http://shakespeare.mit.edu/allswell/full.html'

debug;

title 'Alls Well that Ends Well full play ';

ods _all_ close;

ods listing;

data _null_;

infile allsfull;

file print;

input;

put _infile_;

run;

Re: accessing files on the internet

robm — Wed, 26 Mar 2014 01:39:19 GMT

hey cool thanks

Re: accessing files on the internet

robm — Tue, 01 Apr 2014 14:49:52 GMT

one other thing how would I check each line looking for "index.html"

line in this line

identify that it has index.html in it then strip out

allswell/index.html so that i can use that to build

'http://shakespeare.mit.edu/allswell/full.html'

topic Re: accessing files on the internet in SAS Procedures

accessing files on the internet

Re: accessing files on the internet

Re: accessing files on the internet

Re: accessing files on the internet

Re: accessing files on the internet

Re: accessing files on the internet