Syntax, ODS EXCEL statement:
ODS EXCEL <(<ID=>identifier)> <action>;
ODS EXCEL <(<ID=>identifier)> <option(s)>;
|
ods excel file='multitablefinal.xlsx' /*#1*/ options (sheet_interval="bygroup" /*#2*/ suppress_bylines='yes' /*#3*/ sheet_label='country' /*#4*/ embedded_titles='yes'); /*#5*/ title 'Wage Rates By Manager'; proc means data=cert.usa; by manager; var wagerate; run; ods excel close; /*#6*/
1 | The ODS EXCEL statement opens an instance of an Excel workbook and creates a new Excel workbook called Multitablefinal.xlsx. |
2 | The SHEET_INTERVAL= option creates a new worksheet for each BY group. |
3 | The SUPPRESS_BYLINES= option suppresses the BY lines for each BY group. |
4 | The SHEET_LABEL= option customizes the worksheet label. |
5 | The EMBEDDED_TITLES= option embeds the title that is created by the TITLE statement in the output. |
6 | THE ODS CLOSE statement closes the destination and any associated files. |