Database Reference
In-Depth Information
Example 8.16.9 Methods of Placing Labels in Excel Worksheet Names
Using the “SHEET_LABEL” option with a BY statement causes the string specified by the option to be
used as a prefix that is combined with a numeric value and the BY statement variable name and value to
generate the sheet names by ExcelXP, as shown below as shown in Figure 8.46. The first sheet name is
“One Region 1 - Region=Africa”.
Table 8.16: Options Used in Example 8.16.9.
ExcelXP Option
Setting in Example
Result
SHEET_LABEL
'One Region'
Create a worksheet with the specified
name. When more than one worksheet is
output, the SHEET_LABEL, a number,
and the BY variable and value are used for
the sheet name, up to 32 characters.
Figure 8.45: Code That Uses EXCELXP to Add a Label to All Sheet Names Generated.
ODS TAGSETS.EXCELXP BODY='c:\temp\ExcelXP\shoes9.xml'
OPTIONS(SHEET_LABEL='One Region');
PROC PRINT DATA=sashelp.shoes;
BY region;
RUN;
ODS TAGSETS.EXCELXP CLOSE;
Figure 8.46: Code That Uses the “Sheet_Label” Option to Add a Label to All Sheet Names
Generated.
 
Search WWH ::




Custom Search