DATA Step, Macro, Functions and more

Looking for Example of Reading Spreadsheet from XML file

Reply
Trusted Advisor
Posts: 1,612

Looking for Example of Reading Spreadsheet from XML file

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?

Respected Advisor
Posts: 3,777

Re: Looking for Example of Reading Spreadsheet from XML file

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.

Ask a Question
Discussion stats
  • 1 reply
  • 173 views
  • 0 likes
  • 2 in conversation