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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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