Use Proc Template to Modify styles.normal?

[wcp_fnfg]

Really just trying to do two changes to the normal style:

• Change all border colors from blue to black
• Border the entire box (top and left edges have no border now)

I'm using ODS Tagsets.ExcelXP and Proc Report\Tabulate for outputs.

Thanks!        

[RW9]

You would need to define a new one, inheriting from a base one, e.g.:
proc template;

     define style MyStyles.UpdatedStyle;

     parent = styles.normal;

     style Table /

          bordercolor = cxC1C1C1;

     end;

run;

For what items can be changed, goto the styles (right click on results, select templates, and look at style.default).

[wcp_fnfg]

I know it's something like this, but I used that and my output is still blue borders and has no top\left borders.

FWIW, I'm on EG5.1

[wcp_fnfg]

Attaching the output spreadsheet (minus data for security).

This is my template, but nothing seems to change the border color...

proc template;

     define style styles.Lucy;

     parent = styles.normal;

     replace Header from Header/

          bordercolor = red

   borderstyle = dotted;

     replace Table from Table/

          bordercolor = black;

     replace Data from Data/

          bordercolor = black;

     replace Default from Default/

          bordercolor = black

          frame = box;

     end;

run;

[wcp_fnfg · Accepted solution]

proc template;

  define style styles.lucy;

  parent=styles.normal;

  style Body from Body /

  Pagebreakhtml='<BR> <BR>';

  class header /

  borderleftwidth = 1px

  bordertopwidth = 1px

  borderleftcolor = #000000

  bordertopcolor = #000000

  borderrightcolor = #000000

  borderbottomcolor = #000000

;

  class data /

  borderleftcolor = #000000

  bordertopcolor = #000000

  borderrightcolor = #000000

  borderbottomcolor = #000000

;

  end;

run;