The SAS Output Delivery System and reporting techniques

proc report borders

Reply
Contributor
Posts: 31

proc report borders

Hi! I'd like to have my last two colums have gray borders. Currently they are showing up white//no borders. Any ideas??

 

Here's my code:

 

proc format ;

value pback

low - <0.05= 'ltgray'

50 = 'ltgray'

other = 'white';

value mypval

low - <0.001 = '<0.001'

other = [best5.];

value pfront

50 = 'ltgray'

other = 'black';

run;

 

 

proc report data = perm.normalNT2 nowindows headline headskip missing center

style(report)=[cellspacing=2 borderwidth=2 bordercolor=black]

style(header) = {font_weight = light font_face = 'Times New Roman' font_size = 9pt just = center cellheight=.65in}

style(column) = {font_face = 'Times New Roman' font_size = 9pt just = center /*asis = on*/ cellheight=.22in};

column x y z;

define x / display format = mypval. 'P-Value/for/Normality/Test' center style=[cellwidth=16mm /*cellheight=.2in*/] style(column)=[background=pback.] ;

define y / display format = mypval. 'P-Value/for/Equality/of Means' center style=[cellwidth=15mm /*cellheight=.2in*/] style(column)=[background=pback. foreground =pfront. ] ;

define z / display format = mypval. 'P-Value/for/Equality of/Variances' center style=[cellwidth=17mm /*cellheight=.2in*/] style(column)=[background=pback. foreground =pfront.] ;

 

run;

ods rtf close;

Super User
Posts: 11,765

Re: proc report borders

Posted in reply to nirali514

I'm not going to look at DOCX files from an unknown source.

 

The STYLE section in the define blocks will allow you to set border colors start with bordercolor=gray for the desired columns. You can have separate colors for top, bottom, right and left as well.

 

Your current border definition is coming from you active ODS style.

Ask a Question
Discussion stats
  • 1 reply
  • 124 views
  • 0 likes
  • 2 in conversation