topic ODS EXCEL in SAS Programming

ODS EXCEL

Ronein — Wed, 05 Sep 2018 04:55:05 GMT

Hello

I am working at my work with SAS enterprise guide 5.1

I am trying to work with ODS excel (to learn it).

When I run a code I get en error

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

Maybe This SAS version doesn't support ODS excel?

or maybe there is an error in the code?

ods excel file="/My path/example1.xlsx"
options(embedded_titles='yes'
embedded_footnotes='yes'
tab_color='purple' 
start_at='2,4');
title 'This title will appear in the worksheet';
footnote 'This footnote will appear in the worksheet';
proc report data=sashelp.class;run;
ods excel close;

Re: ODS EXCEL

SASKiwi — Wed, 05 Sep 2018 05:16:39 GMT

What SAS version are you using? ODS Excel was introduced in 9.4 TS1M3 I'm pretty sure.

In the EG Server List, right click on your SAS App server (called maybe SASApp), select Properties, then select the Software tab. This will tell you what version of SAS you are using.

Re: ODS EXCEL

Jagadishkatam — Wed, 05 Sep 2018 06:25:07 GMT

please use the below code to know the sas version

this will give the sas version in sas log.

proc setinit;
run;