Hi Gurus,
I have generated an excel report which contains several tabs with SAS 9.4. I want to produce a table of contents as the first sheet which contains all the sheet names with links that could jump to corresponding tabs.
I used the INDEX='yes' option. But the links in the result TOC is based on the full path of the excel document. If I move the excel or send it buy email, the links will become invalid. Is there any way to fix this issue?
My code is as below:
ods escapechar="^";
ods tagsets.excelxp options(sheet_name="&xlsheetname" index='yes' frozen_headers='yes' frozen_RowHeaders='2' Zoom='80' embedded_titles='yes') ;
title justify=left link="#'Contents'!B1" color=blue underlin=1 '^S={font_style=italic font_size=11pt} TAKE ME TO THE CONTENTS TABLE';
proc report data=&printdata1 nowd split='*' spacing=1 headline missing;
..........; run;
ods tagsets.excelxp options(sheet_name="&xlsheetname" index='yes' frozen_headers='yes' frozen_RowHeaders='2' Zoom='80' embedded_titles='yes') ;
title justify=left link="#'Contents'!B1" color=blue underlin=1 '^S={font_style=italic font_size=11pt} TAKE ME TO THE CONTENTS TABLE';
proc report data=&printdata2 nowd split='*' spacing=1 headline missing;
..........; run;
ods tagsets.ExcelXP close;
Thanks a lot!
