topic Re: Read html from url with Libname OLEDB in SAS Programming

Read html from url with Libname OLEDB

RomanA — Wed, 15 Feb 2012 11:02:16 GMT

Hello

I'm trying to read html data from URL with Libname OLEDB:

options validvarname=V7;

libname tmp OLEDB provider="Microsoft.Jet.OLEDB.4.0"

/* properties=("data source"="\\Pi693pf005\Ukraine_share\Conscensia_from_pa136\Roa\SAS\Kondor-OR\kondor.html") */

provider_string="HTML Import";

data imported;

set tmp."SAS-Eksport1"n;

run;

But received next error:

ERROR: Error trying to establish connection: Unable to Initialize: Cannot update. Database or object is read-only.

ERROR: Error in the LIBNAME statement.

The data on html page is table with a couple of rows and columns.

If I save *.html file physically from above URL, then everything works perfectly.

Can anyone help with such issue?

Ksharp — Fri, 17 Feb 2012 08:01:40 GMT

After checking documentation, I found this. URL is not supported.

DATASOURCE=<'>data-source<'>

identifies the data source object (suchas a relational database server or a local file) to which you want to connect.

Ksharp

SASJedi — Fri, 17 Feb 2012 14:47:27 GMT

Consider using PROC HTTP to download the results of your HTTP request. You may be able to read thelocal copy using OLEDB.

Yuriy2301 — Wed, 22 Feb 2012 13:06:58 GMT

Ok, thanx a lot. I manage to read data to physical file and then use oledb to create data set. Everything works fine.