Read .htm files into SAS dataset

[Oleg_L]

Hello SAS-users.

How can i read .htm files into SAS dataset?

Is it possible?

Now I save .htm files as Excel and use proc import.

Is it the only way?

I use SAS 9.2

Thanks in advance.

Oleg.

[Ksharp]

Is it what you are looking for?

http://communities.sas.com/message/103590#103590

Ksharp

[Oleg_L]

Thanks for your reply Ksharp.

But i can not open your link.

Oleg.

[jonam]

Sometime back i read an interesting article of my friend Pramod @

http://pramod-r.blogspot.com/2011/02/reading-table-from-website-into-sas.html

which describes in detail

Reading a table from a website into a SAS dataset

Hope this helps.

[Oleg_L]

Thank you Jonam.

I will investigate your documentation.

Oleg.

[SASJedi]

Oleg, I've written a workshop for SAS Users Groups called "Untangling the World Wide Web"   You can download a ZIP file containing the PDF and sample SAS code at http://goo.gl/oinmj

[Cekola]

Hi @SASJedi, is that sample SAS code still aailable somewhere for download?

I'm looking for a way to import multiple html files and parse them using SAS, so maybe it would be helpful.

Thanks!

[SASJedi]

Get "Untangling the World Wide Web" from my master links page
http://marksworld.net/jedi

[Cekola]

Thank you so much!!!

[art297]

HTML files can extend across numerous types, layouts, etc.  Did you have anything specific in mind?  Like trying to import a table from a page that you find on the web?

[MikeZdeb]

Hi ... Rick Langston has a couple of papers that might help with reading HTML files

and creating SAS data sets ...

Creating SAS® Data Sets from HTML Table Definitions

http://support.sas.com/resources/papers/proceedings09/052-2009.pdf

and ...

Handling Large Stream Files with the @'string' Feature

http://www2.sas.com/proceedings/forum2007/027-2007.pdf