How to export SAS data to LibreOffice Calc (an open source Excel)

[cashaowan]

I need to export a large SAS dataset to LibreOffice Calc, which is open source Excel similar to MicroOffice Excel. This is due to server restrictions where MicroOffice is not installed. 

I used the following codes:

proc export data=mydata

outfile=''directory\mydata.ods' dbms=ODF replace;

run;

The log file says "DBMS  type ODF not valid for expert". Any solutions? If MicroSoft Office is not allowed, how to take this dataset out? 

[Patrick]

You don't need MS Office installed on the server to create MS Excel files using SAS. You do need SAS Module SAS Access Interface to PC files installed and licensed. 

To check if SAS Access Interface to PC Files is licensed and installed run below commands and then check in the SAS log if it appears.

/* licensed modules */
proc setinit;
run;

/* installed modules */
proc product_status;
run;

To further support you please let us first know if SAS Access Interface to PC Files is available to you.

Btw: What is a "large SAS dataset"? Excel got a limit of 1M rows per sheet.

[Ksharp]

Export it into a CSV file and open it by LibreOffice Calc ?

Or using Python to read in this SAS dataset and export to LibreOffice ?

Or If you have ODBC of LibreOffice you could try LIBNAME + ODBC engine.