Really just trying to do two changes to the normal style:
I'm using ODS Tagsets.ExcelXP and Proc Report\Tabulate for outputs.
Thanks!
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;
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).
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
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;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.