Reputation: 19
I have computed a report from SAS EG that will be emailed to stakeholders. This will be automated, and I want more creative ideas to make this more presentable. Please refer to the code,
filename output email
from=("")
subject= "Update as at &RUN_DT."
to=("")
ct= "text/html"
type="text/html";
ods html body=output style=styles.festival ;
ods noproctitle;
PROC FORMAT;
VALUE WFMT LOW-0.500 = '#FF0000'
0.519 - 0.994 = '#FFA500'
0.995 - HIGH = '#008000';
RUN;
TITLE "Update as at &RUN_DT.";FOOTNOTE;
PROC REPORT DATA=HUBCRMS16 NOWD MISSING
STYLE(HEADER)=[FONT_SIZE=9PT BORDERSTYLE=SOLID BACKGROUND=#94b7ff FOREGROUND=BLACK BORDERWIDTH=1PX]
STYLE(COLUMN)=[FONT_SIZE=8PT BORDERSTYLE=SOLID BORDERWIDTH=1PX]
STYLE(REPORT)=[BORDERSTYLE=SOLID BORDERWIDTH=1PX];;
COLUMN EMPE_NM ASSIGNED TOUCHED TOUCHED_PRECENT UNTOUCHED UNTOUCHED_PRECENT OPEN OPEN_PRECENT SUCCESSFUL SUCCESSFUL_PERCENT DECLINE DECLINE_PRECENT UNSUCCESSFUL UNSUCCESSFUL_PRECENT CONTACTED CONTACTED_PRECENT UNCONTACTED UNCONTACTED_PRECENT _DUMMY;
DEFINE EMPE_NM / GROUP;
DEFINE ASSIGNED / FORMAT=COMMA32.;
DEFINE TOUCHED / FORMAT=COMMA32.;
DEFINE UNTOUCHED / FORMAT=COMMA32.;
DEFINE OPEN / FORMAT=COMMA32.;
DEFINE SUCCESSFUL / FORMAT=COMMA32.;
DEFINE DECLINE / FORMAT=COMMA32.;
DEFINE UNSUCCESSFUL / FORMAT=COMMA32.;
DEFINE CONTACCTED / FORMAT=COMMA32.;
DEFINE UNCONTACCTED / FORMAT=COMMA32.;
DEFINE TOUCHED_PRECENT / COMPUTED FORMAT=PERCENT9.2 STYLE={BACKGROUND=WFMT.};
DEFINE UNTOUCHED_PRECENT / COMPUTED FORMAT=PRECENT9.2 STYLE={BACKGROUND=WFMT.};
DEFINE OPEN_PRECENT / COMPUTED FORMAT=PRECENT9.2 STYLE={BACKGROUND=WFMT.};
DEFINE SUCCESSFUL_PERCENT / COMPUTED FORMAT=PERCENT9.2 STYLE={BACKGROUND=WFMT.};
DEFINE DECLINE_PRECENT / COMPUTED FORMAT=PRECENT9.2 STYLE={BACKGROUND=WFMT.};
DEFINE UNSUCCESSFUL_PRECENT / COMPUTED FORMAT=PERCENT9.2 STYLE={BACKGROUND=WFMT.};
DEFINE CONTACTED_PRECENT / COMPUTED FORMAT=PRECENT9.2 STYLE={BACKGROUND=WFMT.};
DEFINE UNCONTACTED_PRECENT / COMPUTED FORMAT=PRECENT9.2 STYLE={BACKGROUND=WFMT.};
DEFINE _DUMMY / COMPUTED NOPRINT;
RBREAK AFTER / SUMMARIZE;
COMPUTE _DUMMY / CHAR LENGTH=32;
TOUCHED_PRECENT = _C3_ / _C2_ ;
UNTOUCHED_PRECENT=_C4_ / _C2_;
OPEN_PRECENT=_C5_ / _C3_;
SUCCESSFUL_PERCENT = _C6_ / _C3_;
DECLINE_PRECENT= _C7_ / _3_;
UNSUCCESSFUL_PRECENT = _C8_ / _C3_;
CONTACTED_PRECENT= _C9_ / _C3_;
UNCONTACTED_PRECENT= _C10_ / _C3_;
ENDCOMP;
RUN;
ods html close;
ods noproctitle;
The Result: The areas highlighted in Yellow are not a cropping issue. The border doesn't align properly.
I need this table to be more presentable and stylish. The tool version is SAS EG 8. Unfortunately, I can't change it.
Upvotes: 0
Views: 158