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") */
properties=("data source"="http://pi693pa258/sn_drift/kondor_rettelse.nsf/6e2cd21bfc54bf41c12579790034d84d?OpenView&Count=10000...")
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?
After checking documentation, I found this. URL is not supported.
http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001361171.htm
Consider using PROC HTTP to download the results of your HTTP request. You may be able to read thelocal copy using OLEDB.
Ok, thanx a lot. I manage to read data to physical file and then use oledb to create data set. Everything works fine.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.