https://communities.sas.com/t5/ODS-and-Base-Reporting/left-align-TOC-in-tagsets-excelXP/m-p/5954#M2400 for the html destination usage note 23395 shows how to left align all info in the Table of Contents (http://support.sas.com/kb/23/395.html). <BR /> Is there any prospect of getting something like this working for tagsets.excelXP ?<BR /> <BR /> PeterC Tue, 18 Dec 2007 14:52:17 GMT deleted_user 2007-12-18T14:52:17Z https://communities.sas.com/t5/ODS-and-Base-Reporting/left-align-TOC-in-tagsets-excelXP/m-p/5954#M2400 for the html destination usage note 23395 shows how to left align all info in the Table of Contents (http://support.sas.com/kb/23/395.html). <BR /> Is there any prospect of getting something like this working for tagsets.excelXP ?<BR /> <BR /> PeterC Tue, 18 Dec 2007 14:52:17 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/left-align-TOC-in-tagsets-excelXP/m-p/5954#M2400 deleted_user 2007-12-18T14:52:17Z https://communities.sas.com/t5/ODS-and-Base-Reporting/left-align-TOC-in-tagsets-excelXP/m-p/5955#M2401 The index=yes option will create a left aligned index of worksheets in the first worksheet.<BR /> <BR /> Is that what you want?<BR /> <BR /> Eric Wed, 19 Dec 2007 14:58:10 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/left-align-TOC-in-tagsets-excelXP/m-p/5955#M2401 Eric_SAS 2007-12-19T14:58:10Z https://communities.sas.com/t5/ODS-and-Base-Reporting/left-align-TOC-in-tagsets-excelXP/m-p/5956#M2402 Thank you, <BR /> that index= yes option provides a great start.<BR /> It condenses the links into just one column.<BR /> <BR /> 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'.<BR /> <BR /> The big feature is the ability to control text on a ToC<BR /> <BR /> I used this model code to show the comparison[pre]<BR /> ods _all_ close ; <BR /> ods tagsets.excelxp file=odsout( url=none) rs=none <BR /> options(index='yes' contents='yes' <BR /> Embedded_Titles='YES' Embed_Titles_Once='No' )<BR /> ;<BR /> title 'class' ;<BR /> proc sort data= sashelp.class out= class; by sex ;<BR /> title2 j=r 'class in page dim';<BR /> ods tagsets.excelxp options( sheet_name='ClassTable' );<BR /> ods proclabel='A';<BR /> proc tabulate format= best5. contents='2';<BR /> var height weight ;<BR /> class age sex ;<BR /> table age all, mean*( height weight )<BR /> / contents= '3' ;<BR /> run; <BR /> title2 j=r 'by statements' ;<BR /> ods tagsets.excelxp options( sheet_name='PageBy' );<BR /> ods proclabel='B';<BR /> proc tabulate format= best5. contents='4';<BR /> var height weight ;<BR /> class age sex ;<BR /> table sex all<BR /> , age all, mean*( height weight )<BR /> / contents= '5' ;<BR /> by sex ;<BR /> run;<BR /> title2 j=r 'proc print' ;<BR /> ods tagsets.excelxp options( sheet_name='ListBy' );<BR /> ods proclabel='P';<BR /> proc print contents='6'; by sex ; run;<BR /> ods _all_ close ; [/pre]<BR /> <BR /> <BR /> Appreciating the support<BR /> <BR /> PeterC Wed, 19 Dec 2007 15:40:05 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/left-align-TOC-in-tagsets-excelXP/m-p/5956#M2402 deleted_user 2007-12-19T15:40:05Z