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;
... View more