topic Re: Index enhancement with ODS EXCEL in SAS 9.4 m2 in ODS and Base Reporting

Index enhancement with ODS EXCEL in SAS 9.4 m2

Bart_Saviano — Tue, 28 Jun 2016 10:55:52 GMT

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.

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

Cynthia_sas — Tue, 28 Jun 2016 12:17:41 GMT

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

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

Bart_Saviano — Tue, 28 Jun 2016 12:45:48 GMT

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.

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

Tim_SAS — Tue, 28 Jun 2016 12:56:42 GMT

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

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

Bart_Saviano — Tue, 28 Jun 2016 15:11:50 GMT

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).

Re: Index enhancement with ODS EXCEL in SAS 9.4 m2

Tim_SAS — Tue, 28 Jun 2016 15:19:00 GMT

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