%macro Consolidated_reporting; proc format; picture hextraffic low-<0 = "green" other = "lightgrey" ; run; options missing=0; ODS _ALL_ CLOSE; filename mailbox email TO= ('
[email protected]' '
[email protected]' '
[email protected]' '
[email protected]') /*CC=*/ /*(*/ /**/ /*)*/ type='text/html' subject="Alliance MIS Report for the Consolidated partners" ATTACH="F:\IT_Projects\Strategic_Alliance_MBL\Strategic_Alliance_MBLMIS.xlsx"; ods html file=mailbox rs=none ; OPTIONS MISSING=0; PROC ODSTEXT; P "Dear All,"; p " "; p " Please find the attached Consolidated Partners BIL/LAP MIS as on &cur_date. "; p " "; P " Disb Potential is a sum of all Pending Disb cases (mentioned above) and Disbursed Cases" ; p " "; P " Please note that the amount numbers are in lakhs" ; RUN; ODS LAYOUT START COLUMNS=1 WIDTH=40.0IN HEIGHT=4.0IN; ODS REGION; options missing=0; PROC REPORT DATA=final_report3 style(report) = {just=left borderwidth=0.5 font = ('zurich BT',8PT) bordercolor = black} style(header) = {foreground = white background = maroon font = ('zurich BT',8PT) fontweight = bold bordercolor =black} style(column) = {just=left foreground = black borderwidth = 0.5 borderstyle=solid bordercolor = black}; format app_cm_amt 5.2 dis_cm_amt 5.2 dis_cm_count 5.2 log_cm_amt 5.2 TARGET 5.2 DIFF 5.2; format length PARTNER_PRODUCT $32.; COLUMN PARTNER_PRODUCT Partner log_cm_count log_cm_amt app_cm_count app_cm_amt TARGET dis_cm_count dis_cm_amt DIFF ; define PARTNER_PRODUCT/group 'PARTNER_PRODUCT' format=$32. ; DEFINE Partner/GROUP 'PARTNER' ; define log_cm_count/analysis ' LOGIN_CM_CT ' style(column)={just=c CELLWIDTH =1.0in }; define log_cm_amt/analysis 'LOGIN_CM_AMT' style(column)={just=c CELLWIDTH =1.0in }; define app_cm_count/analysis 'APR_CM_AMT' style(column)={just=c CELLWIDTH =1.0in }; define app_cm_amt/analysis 'APR_CM_AMT' style(column)={just=c CELLWIDTH =1.0in }; define target/analysis style(column)={just=c CELLWIDTH =1.0in background=lightbrown}; define dis_cm_count/analysis 'DISB_CM_CT' style(column)={just=c CELLWIDTH =1.0in }; define dis_cm_amt/analysis 'DISB_CM_AMT' style(column)={just=c CELLWIDTH =1.0in background=lightbrown}; define DIFF/computed format=5.2 style(column)={just=c CELLWIDTH =1.0in background=hextraffic.};; compute DIFF/; DIFF=target.sum-dis_cm_amt.sum; endcomp; compute after PARTNER_PRODUCT; PARTNER_PRODUCT='SUBT'; endcomp; /*break after state/summarize;*/ /**/ /*break after zone/summarize;*/ /*rbrEAK AFTER /SUMMARIzE DOL DUL;*/ compute after; PARTNER_PRODUCT= 'TOTAL'; endcomp; break after PARTNER_PRODUCT/summarize style=Header {background=darkbrown foreground=white} ; /*break after PARTNER/summarize style =Header {background=lightyellow} ;*/ rbreak after/summarize style= Header {background=maroon foreground=white FONT_WEIGHT=bold}; run; %mend; Consolidated_reporting;
... View more
