Thank you,
that index= yes option provides a great start.
It condenses the links into just one column.
ODS allows the statement option Contents= and statement ODS ProcLabel= to customize text in a ToC. It would be nice if this was also used on the Worksheets tab created by Index='yes'.
The big feature is the ability to control text on a ToC
I used this model code to show the comparison[pre]
ods _all_ close ;
ods tagsets.excelxp file=odsout( url=none) rs=none
options(index='yes' contents='yes'
Embedded_Titles='YES' Embed_Titles_Once='No' )
;
title 'class' ;
proc sort data= sashelp.class out= class; by sex ;
title2 j=r 'class in page dim';
ods tagsets.excelxp options( sheet_name='ClassTable' );
ods proclabel='A';
proc tabulate format= best5. contents='2';
var height weight ;
class age sex ;
table age all, mean*( height weight )
/ contents= '3' ;
run;
title2 j=r 'by statements' ;
ods tagsets.excelxp options( sheet_name='PageBy' );
ods proclabel='B';
proc tabulate format= best5. contents='4';
var height weight ;
class age sex ;
table sex all
, age all, mean*( height weight )
/ contents= '5' ;
by sex ;
run;
title2 j=r 'proc print' ;
ods tagsets.excelxp options( sheet_name='ListBy' );
ods proclabel='P';
proc print contents='6'; by sex ; run;
ods _all_ close ; [/pre]
Appreciating the support
PeterC