Looking for Example of Reading Spreadsheet from XML file

[PaigeMiller]

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?

[data_null__]

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.