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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
Diamond | Level 26
Hi, then you might need to check with Tech Support. Based on my really quick test, it looks like borderstyle=dotted is not used by ODS PDF.
cynthia

View solution in original post

3 REPLIES 3
Cynthia_sas
Diamond | Level 26

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

 

dotted_not_pdf.png

tekish
Quartz | Level 8

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. 

Cynthia_sas
Diamond | Level 26
Hi, then you might need to check with Tech Support. Based on my really quick test, it looks like borderstyle=dotted is not used by ODS PDF.
cynthia

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 3 replies
  • 1524 views
  • 1 like
  • 2 in conversation