I want to adjust the border lines in the first page and make the border lines as Dotted instead of solid.
Here the the data and mycode.
/******************************************/
/* Fake data for page one */
/******************************************/
data test;
input L$ F$ D$ G$ L$;
cards;
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
L1 FM1 D1 G1 1
;
run;
ods escapechar="^";
options nodate nonumber;
ods pdf startpage=never file="testing.pdf" notoc columns=2;
proc report data=test split='*' nowd headline
style(header)={protectspecialchars=off just=center /*BORDERBottomWIDTH=10*/ borderBottomcolor=black font_size=11pt font_face='Verdana'};
column L F D G L Block ;
define L / noprint;
define F / noprint;
define D / noprint;
define G / noprint;
define L / noprint;
define Block / computed /*flow width=60*/ ' ' style(column)={cellwidth=4in cellheight=3in};
compute Block / char length=3000;
Block =
"^S={just=l font_face='Verdana' font_weight=medium foreground=white} . ."||
"^S={just=l font_face='Verdana' font_weight=medium font_size=12pt foreground=black} Testing Cards"||"^S={}"
||'^n^n'
||"^S={font_face='Verdana' just=c font_size=12pt font_weight=bold}"||' '|| strip(L)||"^S={}"
||"^S={font_face='Verdana' just=c font_size=12pt font_weight=bold}"|| strip(F)||"^S={}"
||'^n^n'
|| "^S={font_face='Verdana' just=c font_size=12pt font_weight=medium}"||" "||'09'x||'09'x||'09'x||'09'x||'09'x||'09'x||'09'x||'09'x||'09'x||"^S={}"
||'^n^n'
|| "^S={font_face='Verdana' just=c font_size=12pt font_weight=bold}"||' '|| D||"^S={}"
||'^n^n^n^n'
|| "^S={font_face='Verdana' just=l font_size=12pt font_weight=medium} "||"^S={}"
||"^S={font_face='Verdana' just=l font_size=12pt font_weight=bold}"|| strip(L)|| "^S={}"
||'^n'
||"^S={font_face='Verdana' just=c font_size=12pt font_weight=medium} "
||'^n^n^n^n'
||"^S={font_face='Verdana' just=l font_size=10pt font_weight=medium font_style=italic}"||'09'x||"^n^n^n^S={}"
||"^S={font_face='Verdana' just=l font_size=8pt font_weight=medium} "||'09'x|| "^S={}"
||"^S={font_face='Verdana' just=l font_size=8pt font_weight=medium}"
;
endcomp;
run;
ods _all_ close;
thanks
Hi, what are "cutlines" and why is everything NOPRINT? And when you say "borderlines" dotted, if you NOPRINT everything, then there are not any borderlines inside the table; with everything NOPRINT, there are no headers and you've put all your style changes onto the Header element, but you don't have any headers in what you show. Do you want the border or frame around the whole table to be dotted? If so, that would have to change in a STYLE(REPORT) override, not a STYLE(HEADER). I'm not sure that PDF supports dotted borderstyle, though, you'd have to check in the documentation for that. When I run a simple test, I see that borderstyle=dotted is used by RTF, but not by PDF.
cynthia
Cyntia,
I apprecaite your immiadiate response.
Basically i am trying to create I Ideal cards size 3 inches high and 3.5 inches wide so that 6 cards fit on each page of a PDF.The frame is dotted line instead of solid.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.