The SAS Output Delivery System and reporting techniques

BORDER in ODS EXCEL

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

BORDER in ODS EXCEL

Hi All,

 

I am looking for borders around each cell in my ODS excel output.

 

Below is template style i am using from but could not get through.

 

proc template;
 define style styles.journal_borders;
 parent = styles.journal;
 style header from header/
 font_weight = bold
 foreground = #CC99FF
 background=yellow
 ;

 style header_right from header /
 borderrightstyle=solid
 borderrightcolor=black
 borderrightwidth=2
 ;
 style header_bottom_right from header_right /
 borderbottomstyle=solid
 borderbottomcolor=black
 borderbottomwidth=2
 ;
 style header_thinbottom_right from header_right /
 borderbottomstyle=solid
 borderbottomcolor=black
 borderbottomwidth=1
 ;
 style header_bottom from header /
 borderbottomstyle=solid
 borderbottomcolor=black
 borderbottomwidth=2
 ;
 style data_bottom from data /
 borderbottomstyle=solid
 borderbottomcolor=black
 borderbottomwidth=1
 ;
 style data_bottom_right from data_bottom /
 borderrightstyle=solid
 borderrightcolor=black
 borderrightwidth=2
 ;
 end;
run;

Please guide.

 

 


Accepted Solutions
Solution
‎06-06-2018 10:18 AM
Super User
Super User
Posts: 9,829

Re: BORDER in ODS EXCEL

Have you looked at the various posts on this, for example:

https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-controlling-borders-not-like-other-ods...

http://support.sas.com/resources/papers/proceedings12/095-2012.pdf

 

It should work, maybe you can present an example of your full code, using sashelp.class?

Also tell us what version of SAS you are using, unix/windows etc.

 

View solution in original post


All Replies
Solution
‎06-06-2018 10:18 AM
Super User
Super User
Posts: 9,829

Re: BORDER in ODS EXCEL

Have you looked at the various posts on this, for example:

https://communities.sas.com/t5/ODS-and-Base-Reporting/ExcelXP-controlling-borders-not-like-other-ods...

http://support.sas.com/resources/papers/proceedings12/095-2012.pdf

 

It should work, maybe you can present an example of your full code, using sashelp.class?

Also tell us what version of SAS you are using, unix/windows etc.

 

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation