Using the following code, a blank page appears as the first page in the report (landscape orientation):
%Let Rpt_FS=[Fontsize=0.3] ;
%Let Rpt_HDR_FS=[fontsize=1 font_weight=light ];
ods PDF file="c:\Portfolio_Report.pdf"
style=HTMLBLUE Startpage=NO pdftoc = 1;
title1 "Analysis for the Period";
proc report data = select_data style(column)=&Rpt_FS
style(header)=[fontsize=1 BACKGROUNDCOLOR=#4F81B9 FOREGROUND=White]
Style(report)=[cellpadding=1 ]
style(summary)=[font_weight=bold bordertopwidth=.1pt bordertopstyle=solid
bordertopcolor=black borderbottomwidth=.1pt borderbottomstyle=solid
borderbottomcolor=black BACKGROUNDCOLOR=#4F81BD FOREGROUND=White] out = xxx;
column mmsort ('Major' major) ('Group' group) ('LOB Market' lob_market)
("Amounts in 000s " rr),balance ;
define mmsort / ' ' group noprint order = internal;
define major/ '' group format = $F_MAJ. mlf style(column)=[cellwidth = 1.0in] ;
define Lob_market / '' group format = $f_lob. mlf order = data style(column)=[cellwidth = 0.9in];
define group / '' group style(column)=[cellwidth = 2.75in];
define rr / ' ' format = f_rr. across order = internal style = [cellwidth = 0.7in] ;
define balance / ' ' format = comma32. ;
compute major/length = 100;
if UPCASE(_break_) = "_RBREAK_" then do;
major = "Total";
end;
else if upcase(_break_) = "MAJOR" and group = ' ' then do;
major = "Total "||strip(major);
end;
endcomp;
compute group / length =100;
if upcase(_break_) = "GROUP" then do;
group = "Total "||strip(group);
major = ' ';
end;
endcomp;
break after major/summarize;
rbreak after / summarize;
break after group/summarize;
run;
ods pdf close;
I found an option that provided the correct result.
What option did you use? I am having the same issue.
Thanks,
Sue
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.