Several years ago I wrote a conference paper about reading non‑standard spreadsheet files called “Help, I’ve Received a Spreadsheet File from StarOffice Calc…..!”, which explained how to extract the XML from a StarOffice Calc file, and then convert that XML into a SAS data set.
OpenDocument spreadsheet files can now be read with both Microsoft Office and LibreOffice (my preferred office suite), but a SAS program still has no way to read this file format directly.
I have now published a SAS program, which works in SAS Software and Altair SLC, to extract all of the individual XML sheets from an OpenDocument spreadsheet into their own SAS data sets. See the “SAS Hints and Tips” chapter in “SAS Programming Experiences: A How-To Guide from a Power SAS User” (both in paperback or PDF formats) for details about this SAS program.
