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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: