BookmarkSubscribeRSS Feed

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.

5 Comments
RW9
Diamond | Level 26
Diamond | Level 26

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.

Kurt_Bremser
Super User

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.

 

 

ballardw
Super User

Perhaps there is a concern about the syntax. ODS ODS might have issues. 😉

ChrisHemedinger
Community Manager

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.

ChrisHemedinger
Community Manager
Status changed to: Not Planned