I am creating a multi sheet report using 4 macros and proc tabulate. each time a macro is called, i define my options, for example ods tagsets.excelxp options ( center_horizontal = 'yes' center_vertical = 'yes' embedded_titles='yes' embedded_footnotes='yes' merge_titles_footnotes = 'yes' sheet_name= &sheet width_points='1' width_fudge='1' absolute_column_width = '80,125,50,50,50,50,50,30,30,30,30,30,30,30,30,30' row_heights = '50,17,20,15,12,10' ); title1 justify=center bold color=grey font=arial height=10pt &title1; title2 justify=center bold color=grey font=arial height=10pt &title2; title3 justify=center bold color=grey font=arial height=10pt &title3; footnote justify=left bold color=grey font=arial height=8pt &source; this creates my first sheet, summary. it goes to column F. every sheet after that has the titles and footnotes also set to only go to column F, not however wide that particular table is. Is there a way to have the titles and footnotes be defined for the particular table on the sheet, not just whatever the first sheets width was?
... View more