Hello,
I am generating some reports in SAS with ODS TAGSETS.EXCELXP. Question is: How would I get a user defined content title in the contents tab. At the moment it's showing sheet_name. I thought sheet_label would work. What I am missing heer? Any thoughts?
ods tagsets.excelxp
file="test.xls" style=sasweb
options(orientation='landscape' embedded_titles='yes' fittopage='yes'
frozen_rowheaders='yes' frozen_headers='5' index='yes'
rowcolheadings='no' print_header='none'
fittopage='yes' row_repeat='1-5'
AUTOFIT_HEIGHT='yes' embedded_titles='yes' embedded_footnotes='yes' zoom='100'
ABSOLUTE_COLUMN_WIDTH='6, 8, 15, 18, 9, 9, 9, 9, 15, 15' sheet_name='Table 1'
sheet_label='Table 1: This is Table 1');
proc print data=sashelp.class;
run;
proc print data=sashelp.cars;
run;
ods tagsets.excelxp close;
Regards,
Ramesh
... View more