Hi to all,
I have a html report which is in megabytes that makes impossible to view using IE.
So,i want to create a sas dataset from that html report .I tried using XML engine to import the html report but somehow it doesn't like it.The following is the code i used.I know i am missing something,but i am not able to find what it is.
Also,my question Is it possible to create a sas dataset from html file.?. If possible please explain how?.
Thanks a lot.
libname xml xml "/pii/saspii/pii/Daily/daily_bigrun100.Html";
libname one "/pii/saspii/pii_testfiles/testbig";
HTML is not XML -- yes, they are both "related" to SGML -- but they are more like distant cousins, than brothers. They are not interchangeable file types. A browser will open and render an XML file, only if the XML file contains an XML processing instruction for a CSS file or an XSL file.
The XML Libname engine is meant to be used on non-hierarchical XML data files. It would not be the appropriate technique to use to read an HTML table into a SAS dataset.