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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.