Creating Output Files with ODS for Use by Excel - Exchanging Data Between SAS and Microsoft Excel - page 139

Table 8.13: Options Used in Example 8.16.6.

ExcelXP Option Setting in Example Result

CONTENTS 'Yes' Turn on the option to produce a

worksheet with a “CONTENTS”
page that lists all of the pages in the
workbook, and provides a hyperlink
to access each page.

Figure 8.39: EXCELXP Options to Create a Table of Contents in an XML Document.
ODS TAGSETS.EXCELXP BODY='c:\temp\ExcelXP\shoes6.xml'
OPTIONS(CONTENTS='Yes');
PROC PRINT DATA=sashelp.shoes;
BY region;
RUN;
ODS TAGSETS.EXCELXP CLOSE;

Figure 8.40: Result of the Execution of SAS Code in Figure 8.39.

I have highlighted the hyperlink that the table of contents generated when writing this Excel workbook.
When you are looking at the table of contents page, holding the mouse over the cell that contains either a
“Region” name or the dataset name will expose the hyperlink instruction fly-over. Simply click on one of
the cells to select the data for viewing.