Hi! Good news, I was able to get the footnote lines switched, so now all I need to do is get all the embedded footnote lines to be left alligned and in Times New Roman font. When there are only 3 lines in the embedded footnote, the 'Copyright' line is not left alligned and is not in Times New Roman, and when there are 4 lines in the embedded footnote, the 'Copyright' line is left alligned, but not in Times New Roman, and the 'Confidential and Proprietary Line' is not left alligned. Any help is appreciated, thanks! %macro footer(sheet,left1,left2); filename DDEcmds dde 'excel|system'; data _null_; file DDECmds; put %unquote(%bquote('[workbook.activate("&sheet")]')); put %unquote(%str(%'[page.setup(%nrbquote("&C&B&16&""Times New Roman""&title.%'%'0d%'x %'&12&A"))]%')); %if &left2 ne %then %do; put %unquote(%str(%'[page.setup(,%nrbquote("&10&L&""Times New Roman""&left1.%'%'0d%'x%'&left2.%'%'0d%'x%'Confidential and Proprietary%'%'0d%'x %'&10&R&""Times New Roman""&P+&page.%'%'0d%'x %'&10&L& %str(Copyright 2014 LLC. All rights reserved.)"))]%'));%end; %else %do; put %unquote(%str(%'[page.setup(,%nrbquote("&10&L&""Times New Roman""&left1.%'%'0d%'x%'Confidential and Proprietary%'%'0d%'x%'&10&R&""Times New Roman""&P+&page.%'%'0d%'x%'&10&L& %str(Copyright 2014 LLC. All rights reserved.)"))]%'));%end; run; %mend footer; %let page=0; %let title=Membership Profile; %let agedate=%str(December 1, 2013); options mprint; %footer(Marital Status,Source: Membership File); %footer(Reported Age,Source: Membership File,%str(Calculated as of: &agedate));
... View more