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
}
