DATA Step, Macro, Functions and more

Read .htm files into SAS dataset

Reply
Regular Contributor
Posts: 151

Read .htm files into SAS dataset

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.

Super User
Posts: 10,035

Read .htm files into SAS dataset

Is it what you are looking for?

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

Ksharp

Regular Contributor
Posts: 151

Read .htm files into SAS dataset

Thanks for your reply Ksharp.

But i can not open your link.

Oleg.

Contributor
Posts: 29

Read .htm files into SAS dataset

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.

Regular Contributor
Posts: 151

Read .htm files into SAS dataset

Thank you Jonam.

I will investigate your documentation.

Oleg.

SAS Employee
Posts: 104

Read .htm files into SAS dataset

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

PROC Star
Posts: 7,477

Re: Read .htm files into SAS dataset

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?

Valued Guide
Posts: 765

Re: Read .htm files into SAS dataset

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

Ask a Question
Discussion stats
  • 7 replies
  • 4387 views
  • 0 likes
  • 6 in conversation