I think it is long overdue that SAS adds support for at least the .ods file format.
Enterprise Guide for export and import
SAS Studio the same
PROC EXPORT and PROC IMPORT
LIBNAME ODS (working like libname xlsx)
Since the core of the ods file format is compressed xml, just as in the modern Microsoft Office formats, this should not be very hard to achieve.
I assume the reason they haven't, other than the lack of comercial pressure, is that OO can read/write native Office documents anyways. Should be done though.
As LibreOffice is my preferred office tool, I usually store spreadsheets as .ods.
As soon as I want to see the data in SAS, I have to re-save in.xls(x) for importing, and that's annoying, given the fact that the basic structure behind both formats is the same.
Perhaps there is a concern about the syntax. ODS ODS might have issues. 😉
I spoke with the developers who would be in charge of this type of feature. It has been considered in the past, but as @RW9 points out, it hasn't been a high priority for customers. And with the ubiquity of the XLSX and RTF formats, which SAS does support, LibreOffice/OpenOffice users have workarounds (although it's not always convenient).
This doesn't close the door on the suggestion, necessarily -- just wanted you to know that it has been on the radar, and more business cases are welcome.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.