topic Use Proc Template to Modify styles.normal? in ODS and Base Reporting

Use Proc Template to Modify styles.normal?

wcp_fnfg — Thu, 26 Jun 2014 12:18:24 GMT

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!

Re: Use Proc Template to Modify styles.normal?

RW9 — Thu, 26 Jun 2014 12:39:42 GMT

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).

Re: Use Proc Template to Modify styles.normal?

wcp_fnfg — Thu, 26 Jun 2014 12:43:43 GMT

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

Re: Use Proc Template to Modify styles.normal?

wcp_fnfg — Thu, 26 Jun 2014 13:21:42 GMT

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;

Re: Use Proc Template to Modify styles.normal?

wcp_fnfg — Thu, 26 Jun 2014 14:51:48 GMT

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;