BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

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;
2 REPLIES 2
SASKiwi
PROC Star

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.  

Jagadishkatam
Amethyst | Level 16

please use the below code to know the sas version

 

this will give the sas version in sas log.

 

proc setinit;
run;
Thanks,
Jag

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1160 views
  • 2 likes
  • 3 in conversation