I am having issues adjusting the frame=hsdies and rules=groups options for my PDF output when using proc template. When I output to RTF I have no issues changing the thickness of the borders using the borderwidth option and when I INCREASE the borderwidth it increases, but when i try to make it thinner, it stays too thick. Unfortunately this table will be part of a CSR that was done externally from my company and our standard macros cannot support a table of its type so I need to solve this isse of simply getting the border to be less thick. Here is my code: 1) The proc template I am using: (I underlined, bolded, and italicized the option that when i increase the value it gets bigger in the PDF but when I decrease it stays too thick...) %let bottommargin= 0.8in;
%let topmargin= 1in;
%let rightmargin= 1in;
%let leftmargin= 1in;
%let frame=hsides;
%let rules=groups;
proc Template;
define style Landscape_8pt;
parent=styles.printer;
replace fonts /
'docFont' =("Courier",8pt)
'FixedFont' =("Courier",8pt)
'BatchFixedFont' =("Courier",8pt)
'FixedStrongFont' =("Courier",8pt)
'FixedHeadingFont' =("Courier",8pt)
'FixedEmphasisFont' =("Courier",8pt)
'EmphasisFont' =("Courier",8pt)
'HeadingEmphasisFont'=("Courier",8pt)
'StrongFont' =("Courier",8pt)
'HeadingFont' =("Courier",8pt)
'TitleFont' =("Courier",8pt)
'TitleFont2' =("Courier",8pt)
'TitleFont3' =("Courier",8pt) ;
style table /
protectspecialchars=off
frame=&frame
width=9in
rules=&rules
font=fonts('docFont')
borderwidth=0.05pt
cellpadding = 1pt
cellspacing = 1pt;
style parskip from parskip /
font=("Courier", 2pt);
replace HeadersAndFooters from Cell /
font = fonts('TitleFont')
foreground=colors('datafg')
background=colors('databg')
protectspecialchars= off;
replace SystemFooter from TitlesAndFooters /
font=fonts('TitleFont3')
protectspecialchars= off
just=c;
replace body from Document /
bottommargin=&bottommargin
topmargin =&topmargin
rightmargin =&rightmargin
leftmargin =&leftmargin
protectspecialchars= off
;
end;
run;
quit; 2) The proc reports (i have taken out and identifying information)
options orientation=landscape linesize=142 nodate nonumber;
ods escapechar='^';
ods pdf file="&outloc./test.pdf" style=Landscape_8pt;
%let LineSize=142;
TItle4 j=center "Table 14.3.1.22.1";
TItle5 j=center "Symptoms and Findings of Differentiation Syndrome from eCRF IDH-DS";
Title6 j=center "(Safety Population)";
PROC REPORT DATA=final_out nowd missing headline headskip spacing=1 split='~' ;
compute after parcat1n;
line'';
endcomp;
COLUMN ( pagen parcat1n paramn _col_1 _col_2 _col_3 _col_4);
DEFINE PAGEN / WIDTH=8 ORDER order noprint " ";
DEFINE PARAMN / WIDTH=8 order noprint " ";
DEFINE PARCAT1N / WIDTH=8 ORDER order noprint " ";
DEFINE _COL_1 / WIDTH=134 id width=80 left flow style=[asis=on]" ";
DEFINE _COL_2 / WIDTH=20 width=17 center "Study~ (N=&n2)";
DEFINE _COL_3 / WIDTH=20 width=17 center "Placebo ~ (N=&n3)";
DEFINE _COL_4 / WIDTH=20 order width=17 center "Total ~ (N=&n4)";
BREAK AFTER pagen / page skip;
BREAK AFTER parcat1n /skip;
run;
PROC REPORT DATA=final_out nowd missing headline headskip spacing=1 split='~';
compute before _page_;
line '^S={just=left} Pre-Selected to WWW';
endcomp;
compute after parcat1n;
line'';
endcomp;
COLUMN ( pagen parcat1n paramn _col_1 _col_5 _col_6 _col_7);
DEFINE PAGEN / WIDTH=8 ORDER order noprint " ";
DEFINE PARAMN / WIDTH=8 order noprint " ";
DEFINE PARCAT1N / WIDTH=8 ORDER order noprint " ";
DEFINE _COL_1 / WIDTH=134 id width=80 left flow style=[asis=on]" ";
DEFINE _COL_5 / WIDTH=20 width=17 center "Study ~ (N=&n5)";
DEFINE _COL_6 / WIDTH=20 width=17 center "Placebo ~ (N=&n6)";
DEFINE _COL_7 / WIDTH=20 width=17 center "Total ~ (N=&n7)";
BREAK AFTER pagen / page skip;
BREAK AFTER parcat1n /skip;
run;
PROC REPORT DATA=final_out nowd missing headline headskip spacing=1 split='~';
compute before _page_;
line '^S={just=left} Pre-Selected to XXX';
endcomp;
compute after parcat1n;
line'';
endcomp;
COLUMN ( pagen parcat1n paramn _col_1 _col_8 _col_9 _col_10);
DEFINE PAGEN / WIDTH=8 ORDER order noprint " ";
DEFINE PARAMN / WIDTH=8 order noprint " ";
DEFINE PARCAT1N / WIDTH=8 ORDER order noprint " ";
DEFINE _COL_1 / WIDTH=134 id width=80 left flow style=[asis=on]" ";
DEFINE _COL_8 / WIDTH=20 width=17 center "Study ~ (N=&n8)";
DEFINE _COL_9 / WIDTH=20 width=17 center "Placebo ~ (N=&n9)";
DEFINE _COL_10 / WIDTH=20 width=17 center "Total ~ (N=&n10)";
BREAK AFTER pagen / page skip;
BREAK AFTER parcat1n /skip;
run;
PROC REPORT DATA=final_out nowd missing headline headskip spacing=1 split='~';
compute before _page_;
line '^S={just=left} Pre-Selected to YYYY';
endcomp;
compute after parcat1n;
line'';
endcomp;
COLUMN ( pagen parcat1n paramn _col_1 _col_11 _col_12 _col_13);
DEFINE PAGEN / WIDTH=8 ORDER order noprint " ";
DEFINE PARAMN / WIDTH=8 order noprint " ";
DEFINE PARCAT1N / WIDTH=8 ORDER order noprint " ";
DEFINE _COL_1 / WIDTH=134 id width=80 left flow style=[asis=on]" ";
DEFINE _COL_11 / WIDTH=20 width=17 center "Study ~ (N=&n11)";
DEFINE _COL_12 / WIDTH=20 width=17 center "Placebo ~ (N=&n12)";
DEFINE _COL_13 / WIDTH=20 width=17 center "Total ~ (N=&n13)";
BREAK AFTER pagen / page skip;
BREAK AFTER parcat1n /skip;
run;
PROC REPORT DATA=final_out nowd missing headline headskip spacing=1 split='~';
compute before _page_;
line '^S={just=left} Pre-Selected to ZZZZ';
endcomp;
compute after parcat1n;
line'';
endcomp;
COLUMN ( pagen parcat1n paramn _col_1 _col_14 _col_15 _col_16);
DEFINE PAGEN / WIDTH=8 ORDER order noprint " ";
DEFINE PARAMN / WIDTH=8 order noprint " ";
DEFINE PARCAT1N / WIDTH=8 ORDER order noprint " ";
DEFINE _COL_1 / WIDTH=134 id width=80 left flow style=[asis=on]" ";
DEFINE _COL_14 / WIDTH=20 width=17 center "Study ~ (N=&n14)";
DEFINE _COL_15 / WIDTH=20 width=17 center "Placebo ~ (N=&n15)";
DEFINE _COL_16 / WIDTH=20 width=17 center "Total ~ (N=&n16)";
BREAK AFTER pagen / page skip;
BREAK AFTER parcat1n /skip;
RUN;
ods pdf close;
... View more
