ODS Excel print_footer with multiple lines

[KTaylor74]

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;

[JosvanderVelden · Accepted solution]

I believe this post https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-I-get-multiple-footnote-lines-in-ODS-EX... has the answer.

[KTaylor74]

Thanks!

I used this for my footer and it worked great!

%let footer_text =%str(&C&7This material is confidential and proprietary. 
Any unauthorized use, reproduction or transfer of these materials is strictly prohibited);