I am running SAS 9.4 and have an ODS Excel question.
I have a footer that I want to see on 2 separate lines in the center section of my report footer. In Excel I would use Shift+ Enter to achieve this carriage return. How do I code this in SAS?
I want the first line of the footer to be "This material is..." and I want the next line of the footer to be "Any unauthorized use...".
My code is:
%let footer_text =%str(&CThis material is confidential and proprietary. Any unauthorized use, reproduction or transfer of these materials is strictly prohibited.&R&7Page &P of &N);
ods listing close;
ods excel file="C:\test.xlsx";
ods excel options(sheet_name="Test"
embedded_titles='yes'
embedded_footnotes='yes'
print_footer="&footer_text"
Orientation = 'landscape');
PROC print DATA=test;
run;
ods excel close;
ods listing;
RUN;