ODS ExcelXp tagsets usage.

The following program will gnerate an output in nicely formatted excel spread sheet.

Please change the file path, sheet name, style and dataset name for your purpose.


ods TAGSETS.EXCELXP file="test.xls"
style=default
options (orientation="Landscape"
AUTOFILTER='1'
FROZEN_HEADER='YES'
FROZEN_ROWHEADER='YES');
ODS TAGSETS.EXCELXP OPTIONS (sheet_name='Sheet_1');
proc print data=d1;
run;
ODS TAGSETS.EXCELXP OPTIONS (sheet_name='Sheet_2');
proc print data=d2;
run;
ods tagsets.excelxp close;