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;
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.
please use the below code to know the sas version
this will give the sas version in sas log.
proc setinit;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.