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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.