BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Doug____
Pyrite | Level 9

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ
Hi:
Without data, no one can test your code. I have seen a few instances of a blank page using ODS TEXT, which I don't see here. Otherwise, you might want to open a track with Tech Support, since they can look at all of your code and your data and see what might be causing the blank page.
Cynthia

View solution in original post

3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
Without data, no one can test your code. I have seen a few instances of a blank page using ODS TEXT, which I don't see here. Otherwise, you might want to open a track with Tech Support, since they can look at all of your code and your data and see what might be causing the blank page.
Cynthia
Doug____
Pyrite | Level 9

I found an option that provided the correct result.

SZimmerman
Calcite | Level 5

What option did you use?  I am having the same issue.

 

Thanks,

 

Sue

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1199 views
  • 0 likes
  • 3 in conversation