The SAS Output Delivery System and reporting techniques

Index enhancement with ODS EXCEL in SAS 9.4 m2

Reply
New Contributor
Posts: 3

Index enhancement with ODS EXCEL in SAS 9.4 m2

Hello, 

I have a question about new SAS 9.4 m2 feature ODS EXCEL. Probably it is a silly quesiton, I'm a beginner with ods.

I'm trying to use the 'index=' suboption wich creates a worksheet that contains an index of all worksheets appearing in the excel report.


ODS excel file="/home/excel_REPORT.xlsx"  options( dpi='300'
embedded_titles='on'
embedded_footnotes='yes'
sheet_interval="page"
index='on')

well, what I woud like to do is to add some enanchements to the index worksheet generated. For istance I would like to insert a title or change font settings for index items. 

Thanks. 

 

 

SAS Super FREQ
Posts: 8,642

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

Hi:
I think you will have to change the STYLE template to do this. What I don't know, and what you might want to ask of Tech Support, is whether there are style elements that you can change which will impact the ODS EXCEL destination.

cynthia
New Contributor
Posts: 3

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

Thanks for the answer. 

What I actually see is that no Excel style template (wich is the default template for ODS excel ) is in my sas release (SAS 9.4 m2). If i run the following code:

 

proc template;
source styles.excel;
run;

 

Here is the log:

 

9304 proc template;
9305 source styles.excel;
WARNING: Path 'Styles.Excel' does not exist!
9306 run;

 

As long as the Excel style should be in the inheritance for any applied style, it is impossible for me to modify it and apply a custom one. It sounds a bit wierd.

 

 

Super Contributor
Posts: 394

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

The default style for ODS EXCEL in 9.4M2 is HTMLBlue.

New Contributor
Posts: 3

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

I'll try to create a new custmized style template starting from HTMLBlue. Thanks. 

I retrived that info, about defult excel style, from the paper attached (page2).

Super Contributor
Posts: 394

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

That tip sheet is accurate for ODS EXCEL in SAS 9.4M3, but not for 9.4M2.

Post a Question
Discussion Stats
  • 5 replies
  • 387 views
  • 2 likes
  • 3 in conversation