topic Re: ods excel in SAS Programming

ods excel

Ronein — Tue, 01 Jan 2019 08:47:06 GMT

Hello

I work with SAS enterprise guide 7.13

I am trying to write ods excel code and I get an error

ERROR: Unable to load module 'SpreadsheetML' from template store!
ERROR: No body file. EXCEL output will not be created.

ods excel file="/path/yourfilename.xlsx";
proc freq data=sashelp.class;
  tables age;
run;
proc freq data=sashelp.class;
  tables sex;
run;
ods excel close;

Re: ods excel

Kurt_Bremser — Tue, 01 Jan 2019 14:06:59 GMT

Which SAS version are you on? According to http://support.sas.com/kb/56/909.html, this needs at least 9.4 M1.

Re: ods excel

Sajid01 — Tue, 01 Jan 2019 17:44:37 GMT

I have just tested your code in SAS Studio

It works.
The log is shown below :

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

NOTE: ODS statements in the SAS Studio environment may disable some output features.

74 ods excel file="/folders/myfolders/Excel/test_01JAN2019.xlsx";

75 /*https://communities.sas.com/t5/SAS-Programming/ods-excel/m-p/523987*/

76 proc freq data=sashelp.class;

77 tables age;

78 run;

NOTE: There were 19 observations read from the data set SASHELP.CLASS.

NOTE: PROCEDURE FREQ used (Total process time):

real time 0.12 seconds

cpu time 0.10 seconds

79 proc freq data=sashelp.class;

80 tables sex;

81 run;

NOTE: There were 19 observations read from the data set SASHELP.CLASS.

NOTE: PROCEDURE FREQ used (Total process time):

real time 0.07 seconds

cpu time 0.05 seconds

82 ods excel close;

NOTE: Writing EXCEL file: /folders/myfolders/Excel/test_01JAN2019.xlsx

84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: ods excel

Reeza — Wed, 02 Jan 2019 00:53:16 GMT

ODS EXCEL is pre-production from SAS 9.4 M1/M2.

It is production as of M3, but still has some bugs. In M5, the version I work with, most bugs are gone and it works decently.

I suspect your version is too old. This will tell you your SAS version in the log.

proc product_status;run;

@Ronein wrote:

Hello

I work with SAS enterprise guide 7.13

I am trying to write ods excel code and I get an error

ERROR: Unable to load module 'SpreadsheetML' from template store!
ERROR: No body file. EXCEL output will not be created.
ods excel file="/path/yourfilename.xlsx";
proc freq data=sashelp.class;
  tables age;
run;
proc freq data=sashelp.class;
  tables sex;
run;
ods excel close;