Database Reference
In-Depth Information
Figure 8.48: Result of Using “SHEET_INTERVAL” to Add a BYGROUP Name to a Sheet
Name.
Example 8.16.11 Use SHEET_INTERVAL= PROC to Create Worksheets
This example uses the SHEET_INTERVAL
option to build a separate worksheet at different intervals. This
ExcelXP option has several values that produce different results. See Table 8.18 for details. Here in this
example we will use the “PROC” setting, and in the last example, 8.16.10, we used the “BYGROUP”
setting. This example writes two worksheets, one for each procedure executed.
Table 8.19: Options Used in Example 8.16.11.
ExcelXP Option
Setting in Example
Result
SHEET_INTERVAL
'PROC'
Create a worksheet with the specified
name. When more than one worksheet is
output, the procedure name and a number
are used for the sheet name, up to 32
characters.
Figure 8.49: Code to Create a Multi-Sheet Workbook with Data for Each Procedure on a
Worksheet.
ODS TAGSETS.EXCELXP BODY='c:\temp\ExcelXP\shoes11.xml'
OPTIONS(SHEET_INTERVAL='PROC');
PROC PRINT DATA=sashelp.shoes;
BY region;
RUN;
************************************************;
Search WWH ::
Custom Search