Hi Cynthia, Apologies for not including more. Here's some dummy data and the template being used so that it replicates the problem upon running. I didn't know that about spacing, headline annd headskip. We mostly create RTFs and I just carried over the options from that. In this example code I tried changing the cell padding in the template definition and observed no difference. Also I have attempted to reduce the width of the column from 1.9 to 1.8 but I just notice that the problem shifts to words that run up against that threshold (in this dummy data, the 3rd entry then crosses). Thank you again. proc template;
define style mypdfstyle;
parent = styles.printer;
style fonts from fonts/
'headingFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'docFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'footFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'TitleFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'TitleFont2' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 10pt, Bold)
'StrongFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'EmphasisFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'FixedEmphasisFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'FixedStrongFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'FixedHeadingFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'BatchFixedFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'FixedFont' = ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
'headingEmphasisFont'= ("Arial, <sans-serif>, <MTsans-serif>, Helvetica, Helv", 8pt)
;
style GraphFonts from GraphFonts /
'headingFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 8pt)
'docFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 8pt)
'footFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 8pt)
'TitleFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 10pt, Bold)
'GraphDataFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 6pt)
'GraphUnicodeFont' = ("<MTserif-unicode> ", 8pt)
'GraphValueFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 7pt)
'GraphLabelFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 8pt)
'GraphFootnoteFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 8pt)
'GraphTitleFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 10pt, Bold)
'GraphAnnoFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv, Arial", 7pt)
;
replace Body from Document /
bottommargin = 0.75in
topmargin = 1in
rightmargin =1in
leftmargin = 1in
;
style usertext from usertext /
font_size=8pt
font_weight=bold
;
replace Table from Output /
frame = BOX
rules = ALL
cellpadding = 1pt
;
style SystemTitle from SystemTitle "Controls system title text." /
protectspecialchars=off
foreground = black
background = white
;
style SystemFooter from SystemFooter "Controls system footer text." /
just=left
protectspecialchars=off
font = Fonts('FootFont')
;
replace color_list /
'link' = blue
'bgh' = white
'fg' = black
'bg' = white
;
end;
run;
data conmed;
length name atcclass route indc $200
date $40
medreas $100;
infile datalines DLM=",";
input dummyvar name $ atcclass $ indc $ route $ date $ medreas $;
datalines;
1,Drug 1/~nDrug 2,ATC CLASSIFICATION 1,Indication 1,Route 1,2099-99-99/~n2099-99-99,Reason 1
1,Drug 1/~nDrug 2,STOMATOLOGICAL PREPARATIONS,Indication 2,Route 2,2099-99-99/~n2099-99-99,Reason 2
1,Drug 1/~nDrug 2,ANTIBACTERIALS FOR SYSTEMIC USE,Indication 2,Route 2,2099-99-99/~n2099-99-99,Reason 2
;
run;
%let s_title=background=white font_weight=bold just=L borderleftcolor=white borderrightcolor=white bordertopcolor=white;
ods escapechar="~";
ods html close;
ods listing close;
options orientation=landscape;
ods pdf file="testfile.pdf" style=mypdfstyle;
proc report data=conmed list nowd missing split='#' wrap nocenter
style(header)={backgroundcolor=cxE0E0E0};
column ("~S={&s_title}Concomitant Medications" (dummyvar name atcclass indc route date medreas));
define dummyvar / order order=data noprint;
define name / display "Reported Name/#Preferred Name" style(header)={width=2.0in font_weight=bold textalign=left} left;
define atcclass / display "ATC Classification" style(header)={width=1.9in font_weight=bold textalign=left} left;
define indc / display "Indication" style(header)={width=1.5in font_weight=bold textalign=left} left;
define route / display "Route" style(header)={width=1.0in font_weight=bold textalign=left} left;
define date / display "Start Date(Day)/#End Date(Day)" style(header)={width=1.0in font_weight=bold textalign=left} left;
define medreas / display "Reason for Medication" style(header)={width=1.5in font_weight=bold textalign=left} left;
break before dummyvar / page contents="";
run;
ods pdf close;
... View more
