Customizing my table border

[guptana123]

Hello,
I am trying to use ODS and Proc Report to create a PDF file.
I want my table (dataset) to have no borders around or between cells, except a single line each time the group breaks. I tried using the foll:
break after aer_no/ul skip

(where aer_no is my group variable)

It still gives me all the other table borders.
I also tried inserting this:
style(report)= {bordercolor=white}

but this doesnt do it either

can you help?
Thanks

 

[ChrisW75]

Check out the Proc Template stuff, that's where you need to go I think.
Start with this, and tweak it as you need to:-

proc template;
   define style Styles.MyStyle;
      parent = styles.default;
      style SystemTitle from SystemTitle /
         background = #FFFFFF
         foreground = #000000
         font_style = Roman
         font_weight = Bold
         font_size = 4
         font_face = "Arial, Helvetica, Sans Serif";

      style SystemFooter from SystemFooter /
         background = #FFFFFF
         foreground = #000000
         font_style = Italic
         font_weight = Bold
         font_size = 3
         font_face = "Arial, Helvetica, Sans Serif";

      style SysTitleAndFooterContainer from SysTitleAndFooterContainer /
         borderwidth = 0
         background = #FFFFFF
         foreground = #FFFFFF
         font_style = Italic
         font_weight = Bold
         font_size = 3
         font_face = "Arial, Helvetica, Sans Serif";

      style Body from Body /
         rightmargin = 8px
         leftmargin = 8px
         background = #FFFFFF
         foreground = #000000
         font_style = Roman
         font_weight = Medium
         font_size = 2
         font = ("Arial, Helvetica, Sans Serif")
         topmargin=0.75in
         bottommargin=0.75in
         leftmargin=0.75in
         rightmargin=0.75in
         ;

      style RowHeader from RowHeader /
         background = #99CCFF
         foreground = #000000
         font_style = Roman
         font_weight = Bold
         font_size = 2
         font = ("Arial, Helvetica, Sans Serif")
         vjust = Top
         borderwidth = 2px
         bordercolor = #000000;

      style Header from Header /
         /*background = #003399*/
         background = #99CCFF
         bordercolor = #000000
         borderwidth = 2px
         foreground = #000000
         font_style = Roman
         font_weight = Bold
         font_size = 2
         just = center
         vjust = bottom
         font = ("Arial, Helvetica, Sans Serif");

      style Data from Data /
         borderwidth = 2px
         bordercolor = #000000
         background = #FFFFFF
         foreground = #000000
         font_style = Roman
         font_weight = Medium
         font_size = 2
         font = ("Arial, Helvetica, Sans Serif");

      style dataemphasis from dataemphasis /
         borderwidth = 3px
         bordercolor = #000000
         background = #99CCFF
         foreground = #000000
         font_style = Roman
         font_weight = BOLD
         font_size = 2
         font = ("Arial, Helvetica, Sans Serif");

      style Table from Table /
         cellspacing = 1px
         bordercolor = #000000
         borderwidth = 0px
         background = #FFFFFF
         foreground = #000000
         font_style = Roman
         font_weight = Medium
         font_size = 2
         font = ("Arial, Helvetica, Sans Serif");
   end;
run;

ods pdf file= ...
   style=mystyle;
 ...

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.