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

Example
Number

General Description

Methods of Naming Excel Worksheets. This example allows you to assign
your own name to a worksheet. It moves away from letting ExcelXP assign
it for you.

8.16.7

8.16.8 Splitting One Report onto Multiple Excel Worksheets. This example uses

the “Sheet_Names” option with a BY statement in the PROC PRINT routine
to apply a prefix to the names of worksheets generated.

Methods of Placing Labels in Excel Worksheet Names. By using the
SHEET_LABEL option with the BY statement in a procedure, you can
create worksheet names that include both the prefix and the BY variable
value as part of the worksheet name.

8.16.9

Use SHEET_INTERVAL= BYGROUP to Create Worksheets. This
example uses the BYGROUP setting of the SHEET_INTERVAL option to
create a worksheet for each BY group of the output. Individual procedures
may create separate output worksheet groups using this option.

8.16.10

Use SHEET_INTERVAL= PROC to Create Worksheets. This example
uses the PROC setting of the SHEET_INTERVAL option to create a
worksheet for each procedure group of the output. This will produce
worksheets with multiple tables on a given worksheet based upon the
number of procedures that are executed.

8.16.11

8.16.12 Build Separate Worksheets with Titles on Each Sheet. This example will

place print-ready titles and footnotes into the Excel workbook. Each sheet
could have unique titles and footnotes.

8.16 EXCELXP Examples to Write XML Files

Example 8.16.1 Generating an XML Output File with No Options
The code in Figure 8.29 produces an XML-formatted file that is acceptable to Microsoft Excel, and many
Internet browsers. The output file can be opened with Excel, and this file has no special options set to
enhance the output. Figure 8.30 shows the output in an Excel worksheet.

Figure 8.29: ExcelXP Code to Write an Excel Workbook File with No Options Set.
ODS TAGSETS.EXCELXP BODY='c:\temp\ExcelXP\shoes1.xml';
PROC PRINT DATA=sashelp.shoes;
RUN;
ODS TAGSETS.EXCELXP CLOSE;