ods excel

[Ronein]

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;

[Kurt_Bremser]

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

[Sajid01]

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.

73

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

83

84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

97

[Reeza]

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;

---