Log { 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 76 77 libname demo '/IT/Rural_Portfolio_Summary/Branch_Summary'; NOTE: Libref DEMO was successfully assigned as follows: Engine: V9 Physical Name: /IT/Rural_Portfolio_Summary/Branch_Summary 78 79 proc sort data=demo.Rural_Sales_MASTER_COmbo out=demo.Rural_Sales_MASTER_CORE_ZONE; 80 by Zone; 81 run; NOTE: There were 919 observations read from the data set DEMO.RURAL_SALES_MASTER_COMBO. NOTE: The data set DEMO.RURAL_SALES_MASTER_CORE_ZONE has 919 observations and 25 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.07 seconds cpu time 0.00 seconds 82 /*----------------ZONE WISE -------------------------------*/ 83 84 DATA _NULL_; 85 Call SymputX('Datetime',put(datetime(),datetime.)); 86 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 87 88 options emailsys=SMTP; 89 options emailhost=CFLMUMCASHUB02.kiac.in; 90 options emailport=25; 91 92 ODS _ALL_ CLOSE; 93 filename mailbox email 94 95 TO= 96 ( 97 'anirudh.saawaant@idfcfirstbank.com', 98 'sachin.thakur@idfcfirstbank.com' 99 ) 100 type='text/html' 101 subject="Rural Sales Summary Zone Wise"; 102 ods html file=mailbox rs=none ; NOTE: Writing HTML Body file: MAILBOX 103 OPTIONS MISSING=0; 104 PROC ODSTEXT; 105 P "Dear All,"; 106 p " "; 107 P "Please find Rural Sales Summary Zone Wise As on &Datetime" ; 108 RUN; NOTE: PROCEDURE ODSTEXT used (Total process time): real time 0.05 seconds cpu time 0.02 seconds 109 ODS LAYOUT START COLUMNS=1 WIDTH=14.0IN HEIGHT=4.0IN; 110 ODS REGION; 111 112 /*------- CONSOLIDATE ZONE WISE REPORT ----------*/ 113 114 PROC REPORT DATA=demo.Rural_Sales_MASTER_CORE_ZONE MISSING 115 style(report) = {just=center borderwidth=0.5 font = ('zurich BT',12PT) bordercolor = black} 116 style(header) = {foreground = WHITE background =maroon font = ('zurich BT',12PT) fontweight = bold bordercolor =black} 117 style(column) = {just=left foreground = black borderwidth = 0.5 borderstyle=solid bordercolor = black}; 118 /*WHERE ZONE IN ('Zone SW','Zone NE');*/ 119 COLUMN ZONE 'FTD(#)'n 'MTD(#)'n 'Target Accounts'n 'SDLM(#)'n 'FTD(Cr.)'n 'MTD(Cr.)'n 'Target Amount'n 'SDLM(Cr.)'n ; 120 DEFINE ZONE/GROUP; 121 /* define 'FTD(#)'n/"FTD_#"; */ 122 define 'Target Accounts'n/"Plan(#)"; 123 define 'Target Amount'n/"Plan (Cr.)"; 124 RBREAK AFTER / SUMMARIZE ; 125 COMPUTE ZONE; 126 IF _BREAK_ ="_RBREAK_" THEN DO ZONE ='Total' ; 127 CALL DEFINE(_ROW_,"STYLE","STYLE={FOREGROUND = WHITE BACKGROUND = MAROON FONT = ('ZURICH BT',12PT) FONTWEIGHT = BOLD}"); 128 END; 129 ENDCOMP; 130 131 RUN; NOTE: There were 919 observations read from the data set DEMO.RURAL_SALES_MASTER_CORE_ZONE. NOTE: PROCEDURE REPORT used (Total process time): real time 0.07 seconds cpu time 0.05 seconds 132 133 PROC REPORT DATA=demo.Rural_Sales_MASTER_CORE_ZONE 134 style(report) = {just=center borderwidth=0.5 font = ('zurich BT',12PT) bordercolor = black} 135 style(header) = {foreground = white background = maroon font = ('zurich BT',12PT) fontweight = bold bordercolor =black} 136 style(column) = {just=left foreground = black borderwidth = 0.5 borderstyle=solid bordercolor = black}; 137 /*col _all_;*/ 138 COLUMN ZONE STATE 'FTD(#)'n 'MTD(#)'n 'Target Accounts'n 'SDLM(#)'n 'FTD(Cr.)'n 'MTD(Cr.)'n 'Target Amount'n 'SDLM(Cr.)'n ; 139 DEFINE ZONE/GROUP; 140 define 'Target Accounts'n/"Plan(#)"; 141 define 'Target Amount'n/"Plan (Cr.)"; 142 define state/group; 143 144 RBREAK AFTER / SUMMARIZE ; 145 COMPUTE STATE; 146 IF _BREAK_ ="_RBREAK_" THEN DO STATE ='Total' ; 147 CALL DEFINE(_ROW_,"STYLE","STYLE={FOREGROUND = WHITE BACKGROUND = MAROON FONT = ('ZURICH BT',12PT) FONTWEIGHT = BOLD}"); 148 END; 149 ENDCOMP; 150 run; NOTE: There were 919 observations read from the data set DEMO.RURAL_SALES_MASTER_CORE_ZONE. NOTE: PROCEDURE REPORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 151 152 /*ZONE WISE PRODUCT BIFERCATION */ 153 PROC REPORT DATA=demo.Rural_Sales_MASTER_CORE_ZONE 154 style(report) = {just=center borderwidth=0.5 font = ('zurich BT',12PT) bordercolor = black} 155 style(header) = {foreground = white background = maroon font = ('zurich BT',12PT) fontweight = bold bordercolor =black} 156 style(column) = {just=left foreground = black borderwidth = 0.5 borderstyle=solid bordercolor = black}; 157 /*col _all_;*/ 158 COLUMN ZONE PRODUCT 'FTD(#)'n 'MTD(#)'n 'Target Accounts'n 'SDLM(#)'n 'FTD(Cr.)'n 'MTD(Cr.)'n 'Target Amount'n 'SDLM(Cr.)'n ; 159 define ZONE/group; 160 define 'Target Accounts'n/'Plan(#)'; 161 define 'Target Amount'n/'Plan (Cr.)'; 162 define product/group; 163 BY ZONE; 164 165 RBREAK AFTER / SUMMARIZE ; 166 COMPUTE PRODUCT; 167 IF _BREAK_ ="_RBREAK_" THEN DO PRODUCT ='Total' ; 168 CALL DEFINE(_ROW_,"STYLE","STYLE={FOREGROUND = WHITE BACKGROUND = MAROON FONT = ('ZURICH BT',12PT) FONTWEIGHT = BOLD}"); 169 END; 170 ENDCOMP; 171 RUN; NOTE: There were 919 observations read from the data set DEMO.RURAL_SALES_MASTER_CORE_ZONE. NOTE: PROCEDURE REPORT used (Total process time): real time 0.10 seconds cpu time 0.11 seconds 172 173 ODS LAYOUT END; 174 ODS HTML CLOSE; ERROR: Email server did not respond. 175 FILENAME MAILBOX CLEAR; NOTE: Fileref MAILBOX has been deassigned. 176 ODS _ALL_ CLOSE; 177 178 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 191 }
... View more