The problem with this solution is that it just adds space below the header, but before the border at the bottom of the header. I am looking to create space below the header border, but before the beginnig of the data. This is easy to do on page 1, but when the data being output spans multiple pages, then there is not a space on pages 2+. Attached is a sample of my current output and below is my code. %MACRO prints;
data _null_;
todate = today();
call symput('todate', put(todate, mmddyy10.));
run;
ods listing close;
ods pdf file = "C:\Users\xxx\Desktop\Test.pdf" pdftoc=1;
ods escapechar = '^';
options orientation=landscape nodate center nonumber nobyline;
proc report data=all4 center split='/' spanrows
style(report) = {font_face = 'timesnewroman'
outputwidth = 100%
outputheight = 100%
just = center
BORDERWIDTH=0
}
style(header) = {font_face = 'timesnewroman' font_size=10pt font_weight=medium
just=center bordertopcolor=black borderbottomcolor=black bordertopwidth=.1px borderbottomwidth=.1px
}
style(column) = {font_face = 'timesnewroman' font_size=9pt cellheight=13pt
};
title1 ;
title2 justify=left font='timesnewroman' height=10pt italic "Test Header Left" font='timesnewroman' height=10pt justify=right "Test Header Right";
title3 justify=left font='timesnewroman' height=10pt italic "Test Header Left 2" font='timesnewroman' height=10pt justify=right "Test Header Right 2";
title4 font='timesnewroman' height=10pt justify=right italic "&todate.";
title5 ;
title6 font='timesnewroman' bold height=14pt justify=center "This a a test Header Row";
title7 font='timesnewroman' bold height=12pt justify=center "Sample Row";
title8 font='timesnewroman' bold height=11pt justify=center "- #byval(Name) -";
by Name;
column Category Band Total Person1 Person2 Person1_Pct Person1_Match Person2_Pct Person2_Match Value;
define Category / order left style(column)=[font_weight=bold width=2.7in] style(header)=[just=left] 'Category';
define Band / display left style(column)=[width=1.7in] 'Band';
define Total / display center 'Total/People';
define Person1 / display center style(column)=[width=1.1in] 'Number of/People 1';
define Person2 / display center style(column)=[width=1.1in] 'Number of/People 2';
define Person1_Pct / display center style(column)=[width=1.1in] 'Percent of/People 1/in Band';
define Person2_Pct / display center style(column)=[width=1.1in] 'Percent of/People 2/in Band';
define Value / display center style(column)=[width=1.1in] 'Final Test Value/of the People';
define Person1_Match / display noprint;
define Person2_Match / display noprint;
compute Value;
if Value <= -3 then call define(_COL_,"style","style={font_weight=bold color=red font_size=10pt}");
endcomp;
compute Person1_Match;
if Person1_Match = 1 then call define('_c6_',"style","style={background=#e6e6e6}");
endcomp;
compute Person2_Match;
if Person2_Match = 1 then call define('_c8_',"style","style={background=#e6e6e6}");
endcomp;
compute after Category / Style={height=0.05in};
line ' ';
endcomp;
footnote1 "^S={outputwidth=100% bordertopcolor=black bordertopwidth=.1px font_face='timesnewroman' just=left vjust=bottom font_size=8pt font_weight=light cellheight=12pt} Note: This is a test footer, test test test.";
footnote2 ;
footnote3 ;
footnote4 justify=center height=9pt font='timesnewroman' 'Page ^{thispage} of ^{lastpage}';
run;
ods pdf close;
ods listing;
%MEND prints;
%prints;
... View more