At NESUG 2007 Eric Gebhart suggested that ODS Markup (https://lexjansen.com/nesug/nesug07/np/np08.pdf) could be used to create ODS destinations for Microsoft Office Open and Oasis Open Document Format (created by LibreOffice and OpenOffice). It is now 2019 and we have ODS EXCEL, POWERPOINT and WORD, but nothing for LibreOffice Calc.
However, I think I know why it hasn't happened, as my attempts to combine tagsets with ODS PACKAGE to create zipped XML files have surfaced a "feature" which limits the XML files concurrently created to just 2, whereas LibreOffice Calc files require at least 3 (content.xml, styles.xml and meta.xml) to be in the zipped package.
Has anyone successfully created an ODS destination for *.ods (LibreOffice Calc) files?...........Phil
Another option occurred to me this evening: could you use PROC JLAUNCHER to create a LibreOffice Calc file from a SAS data set, as there are Java frameworks available to create such files?
Hi:
I remember that paper! Have you tried to just open an XLSX file using LibreOffice. This is a really old post (2012), but at the very bottom, looks like someone had success opening XLSX files: https://askubuntu.com/questions/210213/can-i-open-excel-xlsx-files-with-libreoffice-calc .
Cynthia
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: