Hi. I am unable to export a title and a footnote along with a table to excel using proc report. However, it does print the titles and footnotes along with the tables in the result section. What do I do wrong? Moreover, is it somehow possible to use different sheet names? (I am using SAS Enterprise Guide 7.1.) I really hope someone can help me 🙂 Kind Regards %if %sysfunc(exist(table_1.)) %then %do; ods excel file="\\where_the_excel_output_goes" options(absolute_column_width='30' sheet_interval='PROC' sheet_name='sheetname') style=pearl; title1 "Title1"; footnote "Footnote1"; proc report data=table_1 nowd; run; %end; %if %sysfunc(exist(table_2)) %then %do; title1 "Title2"; footnote "Footnote2"; proc report data=table_2 nowd; run; %end; ods excel close;
... View more