topic Re: help to convert html files into text files in SAS Procedures

help to convert html files into text files

shalmali — Wed, 16 May 2012 00:44:58 GMT

Hello Everyone,

I have almost 12000 html files. I want to convert these html files into text files. Is there any code to import html files in sas and convert it in to text file?

Thank you for your time.

Re: help to convert html files into text files

Tom — Wed, 16 May 2012 00:52:10 GMT

You should just search for html to text converters on the web. Or perhaps html to xml.

If the format is very clean you might be able to read it with a data step.

You might also look into reading them into Excel and then importing into SAS from excel.

Re: help to convert html files into text files

art297 — Wed, 16 May 2012 01:37:09 GMT

Can you provide one as an example?

Re: help to convert html files into text files

Ksharp — Wed, 16 May 2012 02:53:48 GMT

The simplest way is using OLEDB .

Re: help to convert html files into text files

shalmali — Wed, 16 May 2012 04:56:38 GMT

The html files are 10-k reports from SEC edgar. I want to convert these html files into text files. I also have url of these html files.

Re: help to convert html files into text files

Ksharp — Wed, 16 May 2012 06:13:06 GMT

Oh. Maybe you should firstly download all these htmls at your local PC by using PROC HTTP or filename+url .Then using the method I posted convert it into SAS Datasets ,and use proc export to export txt files.

It is easy. I think.

Ksharp