06-28-2016 06:55 AM
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'
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.
06-28-2016 08:17 AM
06-28-2016 08:45 AM
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:
Here is the log:
9304 proc template;
9305 source styles.excel;
WARNING: Path 'Styles.Excel' does not exist!
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.
06-28-2016 11:11 AM