Make sure you have the newest ODS tagset (from support.sas.com somewhere) -
the one that shipped with 9.1.3 was not all that advanced.
On Tue, Dec 2, 2008 at 2:13 PM, Dana M. <email@example.com> wrote:
> Hi all,
> I am new to SAS and ODS so bare with me. I am having trouble creating
> Multi-sheet Excel Workbooks with SAS ODS (SAS 9.1 and Excel 2003). I
> changed my tagsets, to:
> ods tagsets.ExcelXP
> chose a style, changed my file a .xls, ect and ran SAS. What I ended
> up with was an ugly excel file that did not include my titles or
> footers and also split my tables among more tabs than I would have
> chosen. I tried to include the titles, footers, and rearrange the
> tabs with the 'options' tagset code in this general format:
> ods tagsets.ExcelXP options(embedded_titles='yes'
> ods tagsets.ExcelXP options(sheet_name="First Sheet");
> but my log recognized 'options' as a syntax error. I looked for
> online sources to move past this problem but they all show 'options'
> as the code to change the format of the tagset.
> Does anyone have any knowledge in this area they would be willing to
> share or any links to online resources that could help me move past