After opening a track with SAS Technical Support, Chevell Parker came up with this solution, which works like a charm! Thank you, Chevell! TITLE;
FOOTNOTE;
ODS excel file="test.xlsx"
options(sheet_name='TEST_DATA01_05OCT2017D' orientation='portrait'
print_footer="&LInstitutional Research and Assessment (&name) The University of Alabama &R &fdate, Page &P of &N &Z &F");
PROC REPORT DATA=sashelp.class;
define name / style(column)=[just=c];
RUN;
ods excel close; Or, if you want the footnote in a macro variable as we do in our office, your code could look like this: %let footer_text =%str(&LInstitutional Research and Assessment (&name) The University of Alabama &R &fdate, Page &P of &N &Z &F);
TITLE;
FOOTNOTE;
ODS excel file="test.xlsx"
options(sheet_name='TEST_DATA01_05OCT2017D' orientation='portrait'
print_footer="&footer_text");
PROC REPORT DATA=sashelp.class;
define name / style(column)=[just=c];
RUN;
ods excel close; And the output looks like this in both cases:
... View more