The SAS Output Delivery System and reporting techniques

BORDER - ods Excel - Proc report - break after column

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

BORDER - ods Excel - Proc report - break after column

Hi 

 

I would like a border arround the column used in break after option

 

Here is my test program without border :

 

 

  
ods excel file="c:\temp\temp.xlsx";


proc sort data=sashelp.class out=class ;
 by sex ;
run ;


proc report data=class nowd headskip ;

column sex name age height weight;

define sex / order width=3 ;
break after sex /  style=[bordertopcolor=blue borderbottomstyle=solid];
;
 

endcomp;

run ; 

ods excel close;

 

Border.png

Thanks a lot for your help

 

 

 


Accepted Solutions
Solution
‎04-13-2018 05:52 AM
Super User
Super User
Posts: 9,799

Re: BORDER - ods Excel - Proc report - break after column

First turn off the Excel grid, use gridlines="no" in you options.  Then you would need to set each border correctly, so left and right border could be at the procedure level, and the top and bottom border would be missing (or white).  Then in your compute you would compute a style for that one to have top (or bottom) border. pseudocode:

ods excel file="c:\temp\temp.xlsx" options(gridlines="no");
proc sort data=sashelp.class out=class;
 by sex;
run;
proc report data=class nowd headskip 
style(report)=[bordertopcolor=white borderbottomcolor=white borderleftcolor=blue borderrightcolor=blue]; column sex name age height weight; define sex / order width=3;
compute before sex; call style=[bordertopcolor=blue borderbottomstyle=solid]; endcomp; run; ods excel close;
 

View solution in original post


All Replies
Solution
‎04-13-2018 05:52 AM
Super User
Super User
Posts: 9,799

Re: BORDER - ods Excel - Proc report - break after column

First turn off the Excel grid, use gridlines="no" in you options.  Then you would need to set each border correctly, so left and right border could be at the procedure level, and the top and bottom border would be missing (or white).  Then in your compute you would compute a style for that one to have top (or bottom) border. pseudocode:

ods excel file="c:\temp\temp.xlsx" options(gridlines="no");
proc sort data=sashelp.class out=class;
 by sex;
run;
proc report data=class nowd headskip 
style(report)=[bordertopcolor=white borderbottomcolor=white borderleftcolor=blue borderrightcolor=blue]; column sex name age height weight; define sex / order width=3;
compute before sex; call style=[bordertopcolor=blue borderbottomstyle=solid]; endcomp; run; ods excel close;
 
New Contributor
Posts: 2

Re: BORDER - ods Excel - Proc report - break after column

Thanks a lot RW9

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 209 views
  • 0 likes
  • 2 in conversation