topic ODS Excel print_footer with multiple lines in New SAS User

ODS Excel print_footer with multiple lines

KTaylor74 — Thu, 05 Dec 2019 20:06:51 GMT

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;

Re: ODS Excel print_footer with multiple lines

JosvanderVelden — Fri, 06 Dec 2019 09:55:28 GMT

I believe this post https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-I-get-multiple-footnote-lines-in-ODS-EXCEL-using-options/m-p/437685/highlight/true#M20406 has the answer.

Re: ODS Excel print_footer with multiple lines

KTaylor74 — Fri, 06 Dec 2019 15:33:09 GMT

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);