topic Re: Read .htm files into SAS dataset in SAS Programming

Read .htm files into SAS dataset

Oleg_L — Fri, 16 Sep 2011 07:35:48 GMT

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.

Read .htm files into SAS dataset

Ksharp — Fri, 16 Sep 2011 09:56:20 GMT

Is it what you are looking for?

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

Ksharp

Read .htm files into SAS dataset

jonam — Fri, 16 Sep 2011 10:33:28 GMT

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.

Read .htm files into SAS dataset

Oleg_L — Fri, 16 Sep 2011 15:01:01 GMT

Thanks for your reply Ksharp.

But i can not open your link.

Oleg.

Read .htm files into SAS dataset

Oleg_L — Fri, 16 Sep 2011 15:04:22 GMT

Thank you Jonam.

I will investigate your documentation.

Oleg.

Read .htm files into SAS dataset

SASJedi — Sat, 17 Sep 2011 16:54:57 GMT

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

Re: Read .htm files into SAS dataset

art297 — Sat, 17 Sep 2011 17:31:01 GMT

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?

Re: Read .htm files into SAS dataset

MikeZdeb — Thu, 22 Sep 2011 20:29:29 GMT

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

Re: Read .htm files into SAS dataset

Cekola — Tue, 14 Sep 2021 04:01:21 GMT

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!

Re: Read .htm files into SAS dataset

SASJedi — Sun, 19 Sep 2021 17:19:00 GMT

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

Re: Read .htm files into SAS dataset

Cekola — Sun, 19 Sep 2021 19:35:11 GMT

Thank you so much!!!