05-09-2014 09:48 AM
In the past, I have created spreadsheets as .xml files, and then distributed them to appropriate individuals.
Now, I have a need to read data from an archive of these .xml files.
Does anyone have an example of SAS code to read spreadsheets from .xml files?
05-11-2014 08:27 AM
Maybe you can get somewhere with this but I don't know much about details.
Start with this XML map http://support.sas.com/kb/45/addl/fusion_45192_1_excelxp.map
You will need a libname to point to the XML with with XMLMAP option pointing to the file in the
libname MYXML xml "path-to-myxmlfile.xml" xmlmap="path-excelxp.map";
The try proc datasets or contents to see names of the objects in the library and work your way from there.