Hello
I am using ODS excel to export from sas into XLSX.
I get this warning
WARNING: Unsupported device 'SVG' for EXCEL destination. Using default device 'PNG'.
Here is full log
1 The SAS System 07:59 Monday, June 23, 2025
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='R7_Dynamic_one_Mon_Run.sas';
4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='M:\aתחום מודלים\CS_בקרות\בקרת ציון כא -רמת יישות\Program_to_Run\R7_Dynamic_one_Mon_Run.sas';
9 %LET _SASPROGRAMFILEHOST='HKSU102561A79';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
NOTE: The ACCESSIBLE_GRAPH option is pre-production for this release.
21 ENCODING='utf-8'
22 STYLE=HTMLBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28
29 /****Step3---Create pelets----MUST run step2 before step3!!!****/
30 /****Step3---Create pelets----MUST run step2 before step3!!!****/
31 /****Step3---Create pelets----MUST run step2 before step3!!!****/
32 /****Step3---Create pelets----MUST run step2 before step3!!!****/
33 %let datetime = %sysfunc(datetime(), datetime20.) ;
34 %let datetime_clean = %sysfunc(translate(&datetime,_, %str(: ))) ;
35
36 %let path="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/Bakara_CrdRate_&datetime_clean..xlsx";
37 proc sql noprint;
38 select max(mon) as last_mon_in_Report_YYMM1 into :last_mon_in_Report_YYMM1
39 from NP_S1
40 ;
41 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5324.03k
OS Memory 31660.00k
Timestamp 06/23/2025 09:56:32 AM
Step Count 203 Switch Count 0
Page Faults 0
Page Reclaims 31
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
2 The SAS System 07:59 Monday, June 23, 2025
42 %put last_mon_in_Report_YYMM1=&last_mon_in_Report_YYMM1;
last_mon_in_Report_YYMM1= 2505
43
44
45 proc sql noprint;
46 select max(mon) as last_mon_in_Report_YYMM2 into :last_mon_in_Report_YYMM2
47 from NP_S6
48 ;
49 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5320.12k
OS Memory 31916.00k
Timestamp 06/23/2025 09:56:32 AM
Step Count 204 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
50 %put last_mon_in_Report_YYMM2=&last_mon_in_Report_YYMM2;
last_mon_in_Report_YYMM2= 2405
51
52
53 data _null_;
54 ddate=input("&last_mon_in_Report_YYMM1.",yymmn4.);
55 prev=intnx('month',ddate,-1);
56 prev_YYMM=input(put(prev,yymmn4.),best.);
57 format ddate prev ddmmyy10.;
58 call symputx('prev_YYMM',prev_YYMM);
59 Run;
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 55:6
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 341.78k
OS Memory 26792.00k
Timestamp 06/23/2025 09:56:32 AM
Step Count 205 Switch Count 0
Page Faults 0
Page Reclaims 22
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
3 The SAS System 07:59 Monday, June 23, 2025
60 %put prev_YYMM=&prev_YYMM;
prev_YYMM=.
61
62
63
64
65 /****Pelet S1--No pepper***/
66 /****Pelet S1--No pepper***/
67 /****Pelet S1--No pepper***/
68 proc sql noprint;
69 select NP_IND_Prob as Ind_NP_S1_lastMon into :Ind_NP_S1_lastMon
70 from NP_S1
71 where mon=&last_mon_in_Report_YYMM1.
72 ;
73 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5324.03k
OS Memory 31916.00k
Timestamp 06/23/2025 09:56:32 AM
Step Count 206 Switch Count 0
Page Faults 0
Page Reclaims 10
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
74 %put Ind_NP_S1_lastMon=&Ind_NP_S1_lastMon.;
Ind_NP_S1_lastMon= 0
75
76 proc sql noprint;
77 select case when &Ind_NP_S1_lastMon.=1 then 'Red'
78 when max(NP_IND_Prob)=1 then 'Orange'
79 else 'Green'
80 end as Ind_Color_Sheet_NP_S1 into : Ind_Color_Sheet_NP_S1
81 from NP_S1
82 ;
83 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5324.03k
OS Memory 31916.00k
Timestamp 06/23/2025 09:56:32 AM
Step Count 207 Switch Count 0
Page Faults 0
Page Reclaims 11
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
4 The SAS System 07:59 Monday, June 23, 2025
Block Input Operations 0
Block Output Operations 0
84 %put Ind_Color_Sheet_NP_S1=&Ind_Color_Sheet_NP_S1.;
Ind_Color_Sheet_NP_S1=Green
85
86
87 /*Bakara_Crd_Rate*/
88 /*ODS _ALL_ CLOSE; */
89 /**to prevent print on screen***/
90
91 ods excel file=&path.
92 options (sheet_name='NP_S1'
93 embedded_titles='yes'
94 embedded_footnotes='yes'
95 sheet_interval="proc" /***One table in sheet**/
96 gridlines = 'yes'
97 tab_color="&Ind_Color_Sheet_NP_S1."
98 );
WARNING: Unsupported device 'SVG' for EXCEL destination. Using default device 'PNG'.
99
100 title;
101 title1 bold color=red height=5 font=simplex 'בקרת תמהיל ציון כא ריק או חיובי';
102 title2 bold color=red height=5 font=simplex 'קריטריון להדלקה- שינוי לפחות 3% בתמהיל יישויות בעלות ציון כא חיובי';
103 title3 bold color=red height=4 font=simplex 'אוכלוסייה-יישויות_שאינן_פפר-אינן_חטיבה_860_ואינן_סניף_998';
104 title4 bold color=black height=4 font=simplex 'הערה-ציון כא יכול ליהיות עם ערך ריק מ-2 סיבות אפשריות- לא פרי קלין או
104 ! פריקלין ללא ניצול כא בשנה אחרונה';
105 title5 bold color=black height=4 font=simplex 'אוכלוסיה_PCS_Y';
106 title6 bold color=black height=4 font=simplex 'בקרת קבצי : ADD.EXTRAS_YYMM_CCHIVE';
107 title7 bold color=black height=4 font=simplex 'הערה- זיהוי פרי קלין לפי קבצי פרי קלין והם קיימים החל מ2206';
108 proc report data=NP_S1 missing nowd split='*';
109 column
110 NP_IND_Prob
111 mon
112 table_name
113
114 ("מספר_יישויות"
115 NP_Nr
116 NP_NrY_POS
117 NP_NrY_Null
118 NP_NrY_NoPreClean
119 NP_NrY_PreClean_NoCrd)
120
121 ("תמהיל_יישויות"
122 NP_Tamhil_NrY_POS
123 NP_Tamhil_NrY_Null
124 NP_Tamhil_NrY_NoPreClean
125 NP_Tamhil_NrY_PreClean_NoCrd)
126
127 ("הפרש_בתמהיל_מחודש_קודם"
128 NP_DIF_Tamhil_NrY_POS
129 NP_DIF_Tamhil_NrY_Null
130 NP_DIF_Tamhil_NrY_NoPreClean
131 NP_DIF_Tamhil_NrY_PreClean_NoCrd)
132 ;
133 define NP_IND_Prob / 'אינד להדלקה' DISPLAY;
134
5 The SAS System 07:59 Monday, June 23, 2025
135 define mon / 'חודש' DISPLAY;
136 define table_name / 'שם טבלה' DISPLAY;
137
138 define NP_Nr / 'מספר יישויות' DISPLAY format=comma32.;
139 define NP_NrY_POS / ' ציון כא חיובי' DISPLAY format=comma32.;
140 define NP_NrY_Null / ' ציון כא ריק' DISPLAY format=comma32.;
141 define NP_NrY_NoPreClean / 'ציון כא ריק* מסיבת* לא פרי קלין' DISPLAY format=comma32.;
142 define NP_NrY_PreClean_NoCrd / 'ציון כא ריק* מסיבת *פריקלין ללא ניצול כא' DISPLAY format=comma32.;
143
144 define NP_Tamhil_NrY_POS / 'ציון כא חיובי' DISPLAY;
145 define NP_Tamhil_NrY_Null / 'ציון כא ריק' DISPLAY;
146 define NP_Tamhil_NrY_NoPreClean / 'ציון כא ריק* מסיבת *לא פרי קלין' DISPLAY;
147 define NP_Tamhil_NrY_PreClean_NoCrd / 'ציון כא ריק* מסיבת* פריקלין ללא ניצול כא' DISPLAY;
148
149 define NP_DIF_Tamhil_NrY_POS / 'ציון כא חיובי' DISPLAY;
150 define NP_DIF_Tamhil_NrY_Null / 'ציון כא ריק' DISPLAY;
151 define NP_DIF_Tamhil_NrY_NoPreClean / 'ציון כא ריק* מסיבת *לא פרי קלין' DISPLAY;
152 define NP_DIF_Tamhil_NrY_PreClean_NoCrd / 'ציון כא ריק* מסיבת* פריקלין ללא ניצול כא' DISPLAY;
153
154
155 compute NP_IND_Prob;
156 if NP_IND_Prob = 0 then
157 do;
158 call define (_col_,"style", "style={background=lightgreen}");
159 end;
160 else if NP_IND_Prob =1 then
161 do;
162 call define (_col_,"style", "style={background=lightred}");
163 end;
164 endcomp;
165
166 compute NP_DIF_Tamhil_NrY_POS;
167 if _c13_ >0.03 then do;
168 call define ('_c13_',"style", "style={background=lightred}");
169 call define ('_c4_',"style", "style={background=lightred}");
170 call define ('_c9_',"style", "style={background=lightred}");
171 end;
172 endcomp;
173
174 compute NP_DIF_Tamhil_NrY_Null;
175 if _c14_ >0.03 then do;
176 call define ('_c14_',"style", "style={background=lightred}");
177 call define ('_c5_',"style", "style={background=lightred}");
178 call define ('_c10_',"style", "style={background=lightred}");
179 end;
180 endcomp;
181
182 compute NP_DIF_Tamhil_NrY_NoPreClean;
183 if _c15_ >0.03 then do;
184 call define ('_c15_',"style", "style={background=lightred}");
185 call define ('_c6_',"style", "style={background=lightred}");
186 call define ('_c11_',"style", "style={background=lightred}");
187 end;
188 endcomp;
189
190
191 compute NP_DIF_Tamhil_NrY_PreClean_NoCrd;
192 if _c16_ >0.03 then do;
6 The SAS System 07:59 Monday, June 23, 2025
193 call define ('_c16_',"style", "style={background=lightred}");
194 call define ('_c7_',"style", "style={background=lightred}");
195 call define ('_c12_',"style", "style={background=lightred}");
196 end;
197 endcomp;
198 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 41 observations read from the data set WORK.NP_S1.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.35 seconds
user cpu time 0.33 seconds
system cpu time 0.01 seconds
memory 12864.93k
OS Memory 46048.00k
Timestamp 06/23/2025 09:56:32 AM
Step Count 208 Switch Count 0
Page Faults 0
Page Reclaims 3815
Page Swaps 0
Voluntary Context Switches 20
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
199
200
201
202 /****Pelet S1-- pepper***/
203 /****Pelet S1-- pepper***/
204 /****Pelet S1-- pepper***/
205 /**נדרש תיקון אך ורק ב2201-2206 בלל שבחודשים הללו אין פרי קלין**/
206 proc sql noprint;
207 select P_IND_Prob as Ind_P_S1_lastMon into :Ind_P_S1_lastMon
208 from P_S1
209 where mon=&last_mon_in_Report_YYMM1. and mon>=2502
210 ;
211 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5324.18k
OS Memory 46032.00k
Timestamp 06/23/2025 09:56:32 AM
Step Count 209 Switch Count 0
Page Faults 0
Page Reclaims 17
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
212 %put Ind_P_S1_lastMon=&Ind_P_S1_lastMon.;
Ind_P_S1_lastMon= 0
7 The SAS System 07:59 Monday, June 23, 2025
213
214 proc sql noprint;
215 select case when &Ind_P_S1_lastMon.=1 then 'Red'
216 when max(P_IND_Prob)=1 then 'Orange'
217 else 'Green'
218 end as Ind_Color_Sheet_P_S1 into : Ind_Color_Sheet_P_S1
219 from P_S1
220 where mon>=2502
221 ;
222 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5324.28k
OS Memory 46032.00k
Timestamp 06/23/2025 09:56:32 AM
Step Count 210 Switch Count 0
Page Faults 0
Page Reclaims 10
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
223 %put Ind_Color_Sheet_P_S1=&Ind_Color_Sheet_P_S1.;
Ind_Color_Sheet_P_S1=Green
224
225
226 ods excel options (sheet_name='P_S1'
227 sheet_interval="proc" /**One table in sheet***/
228 gridlines = 'yes'
229 tab_color="&Ind_Color_Sheet_P_S1."
230 );
231 title;
232 title;
233 title1 bold color=red height=5 font=simplex 'בקרת תמהיל ציון כא ריק או חיובי';
234 title2 bold color=red height=5 font=simplex 'קריטריון להדלקה- שינוי לפחות 3% בתמהיל יישויות בעלות ציון כא חיובי';
235 title3 bold color=red height=5 font=simplex 'אוכלוסייה-יישויות_פפר-חטיבה_860_או_סניף_998';
236 title4 bold color=red height=5 font=simplex 'הדלקת גליון-החל מ 2502 בגלל שזה פפר';
237 title5 bold color=black height=4 font=simplex 'הערה-ציון כא יכול ליהיות עם ערך ריק מ-2 סיבות אפשריות- לא פרי קלין או
237 ! פריקלין ללא ניצול כא בשנה אחרונה';
238 title6 bold color=black height=4 font=simplex 'אוכלוסיה_PCS_Y';
239 title7 bold color=black height=4 font=simplex 'בקרת קבצי : ADD.EXTRAS_YYMM_CCHIVE';
240 title8 bold color=black height=4 font=simplex 'הערה- זיהוי פרי קלין לפי קבצי פרי קלין והם קיימים החל מ2206';
241 proc report data=P_S1 missing nowd split='*';
242 column
243 P_IND_Prob
244 mon
245 table_name
246
247 ("מספר_יישויות"
248 P_Nr
249 P_NrY_POS
250 P_NrY_Null
251 P_NrY_NoPreClean
8 The SAS System 07:59 Monday, June 23, 2025
252 P_NrY_PreClean_NoCrd)
253
254 ("תמהיל_יישויות"
255 P_Tamhil_NrY_POS
256 P_Tamhil_NrY_Null
257 P_Tamhil_NrY_NoPreClean
258 P_Tamhil_NrY_PreClean_NoCrd)
259
260 ("הפרש_בתמהיל_מחודש_קודם"
261 P_DIF_Tamhil_NrY_POS
262 P_DIF_Tamhil_NrY_Null
263 P_DIF_Tamhil_NrY_NoPreClean
264 P_DIF_Tamhil_NrY_PreClean_NoCrd)
265 ;
266 define P_IND_Prob / 'אינד להדלקה' DISPLAY;
267
268 define mon / 'חודש' DISPLAY;
269 define table_name / 'שם טבלה' DISPLAY;
270
271 define P_Nr / 'מספר יישויות' DISPLAY format=comma32.;
272 define P_NrY_POS / ' ציון כא חיובי' DISPLAY format=comma32.;
273 define P_NrY_Null / ' ציון כא ריק' DISPLAY format=comma32.;
274 define P_NrY_NoPreClean / 'ציון כא ריק* מסיבת* לא פרי קלין' DISPLAY format=comma32.;
275 define P_NrY_PreClean_NoCrd / 'ציון כא ריק* מסיבת *פריקלין ללא ניצול כא' DISPLAY format=comma32.;
276
277 define P_Tamhil_NrY_POS / 'ציון כא חיובי' DISPLAY;
278 define P_Tamhil_NrY_Null / 'ציון כא ריק' DISPLAY;
279 define P_Tamhil_NrY_NoPreClean / 'ציון כא ריק* מסיבת *לא פרי קלין' DISPLAY;
280 define P_Tamhil_NrY_PreClean_NoCrd / 'ציון כא ריק* מסיבת* פריקלין ללא ניצול כא' DISPLAY;
281
282 define P_DIF_Tamhil_NrY_POS / 'ציון כא חיובי' DISPLAY;
283 define P_DIF_Tamhil_NrY_Null / 'ציון כא ריק' DISPLAY;
284 define P_DIF_Tamhil_NrY_NoPreClean / 'ציון כא ריק* מסיבת *לא פרי קלין' DISPLAY;
285 define P_DIF_Tamhil_NrY_PreClean_NoCrd / 'ציון כא ריק* מסיבת* פריקלין ללא ניצול כא' DISPLAY;
286
287
288 compute P_IND_Prob;
289 if P_IND_Prob = 0 then
290 do;
291 call define (_col_,"style", "style={background=lightgreen}");
292 end;
293 else if P_IND_Prob =1 then
294 do;
295 call define (_col_,"style", "style={background=lightred}");
296 end;
297 endcomp;
298
299 compute P_DIF_Tamhil_NrY_POS;
300 if _c13_ >0.03 then do;
301 call define ('_c13_',"style", "style={background=lightred}");
302 call define ('_c5_',"style", "style={background=lightred}");
303 call define ('_c9_',"style", "style={background=lightred}");
304 end;
305 endcomp;
306
307 compute P_DIF_Tamhil_NrY_Null;
308 if _c14_ >0.03 then do;
309 call define ('_c14_',"style", "style={background=lightred}");
9 The SAS System 07:59 Monday, June 23, 2025
310 call define ('_c6_',"style", "style={background=lightred}");
311 call define ('_c10_',"style", "style={background=lightred}");
312 end;
313 endcomp;
314
315 compute P_DIF_Tamhil_NrY_NoPreClean;
316 if _c15_ >0.03 then do;
317 call define ('_c15_',"style", "style={background=lightred}");
318 call define ('_c7_',"style", "style={background=lightred}");
319 call define ('_c11_',"style", "style={background=lightred}");
320 end;
321 endcomp;
322
323
324 compute P_DIF_Tamhil_NrY_PreClean_NoCrd;
325 if _c16_ >0.03 then do;
326 call define ('_c16_',"style", "style={background=lightred}");
327 call define ('_c8_',"style", "style={background=lightred}");
328 call define ('_c12_',"style", "style={background=lightred}");
329 end;
330 endcomp;
331 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 41 observations read from the data set WORK.P_S1.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.33 seconds
user cpu time 0.32 seconds
system cpu time 0.01 seconds
memory 7806.43k
OS Memory 46816.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 211 Switch Count 0
Page Faults 0
Page Reclaims 1536
Page Swaps 0
Voluntary Context Switches 19
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
332
333
334
335 /***Pelet S1-b------No_Pepper+Pepper all together in one report***/
336 /***Pelet S1-b------No_Pepper+Pepper all together in one report***/
337 /***Pelet S1-b------No_Pepper+Pepper all together in one report***/
338 proc sql noprint;
339 select Ind_Prob as Ind_S1b_lastMon into :Ind_S1b_lastMon
340 from S1b
341 where mon=&last_mon_in_Report_YYMM1.
342 ;
343 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
10 The SAS System 07:59 Monday, June 23, 2025
memory 5320.21k
OS Memory 46544.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 212 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
344 %put Ind_S1b_lastMon=&Ind_S1b_lastMon.;
Ind_S1b_lastMon= 0
345
346
347 proc sql noprint;
348 select case when &Ind_S1b_lastMon.=1 then 'Red'
349 when max(Ind_Prob)=1 then 'Orange'
350 else 'Green'
351 end as Ind_Color_Sheet_S1_b into : Ind_Color_Sheet_S1_b
352 from S1b
353 ;
354 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 5320.21k
OS Memory 46544.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 213 Switch Count 0
Page Faults 0
Page Reclaims 11
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
355 %put Ind_Color_Sheet_S1_b=&Ind_Color_Sheet_S1_b.;
Ind_Color_Sheet_S1_b=Green
356
357
358 ods excel options (sheet_name='S1-b'
359 sheet_interval="proc" /**One table in sheet**/
360 gridlines = 'yes'
361 tab_color="&Ind_Color_Sheet_S1_b."
362 );
363 title;
364 title1 bold color=red height=5 font=simplex 'בדיקת תקינות ערכי ציון כא';
365 title2 bold color=red height=5 font=simplex 'קריטריון להדלקה-קיימות יישויות עם ציון כא שלילי או 0 או מעל 1';
366 title3 bold color=red height=5 font=simplex 'אוכלוסייה--כלל יישויות פפר ולא פפר שקיימות בקבצי -----CCHIVE';
367 title4 bold color=black height=5 font=simplex 'בקרת קבצי : ADD.EXTRAS_YYMM_CCHIVE';
368 proc report data=S1b missing nowd split='*';
369 column
11 The SAS System 07:59 Monday, June 23, 2025
370 ind_prob
371 mon
372 table_name
373
374 ("מספר יישויות"
375 Nr_Rows
376 NR_Nulls
377 NR_POS_Ad1
378 NR_POS_MAAL1
379 NR_NEG
380 NR_0)
381 ;
382 define IND_Prob / 'אינד להדלקה' DISPLAY;
383 define mon / 'חודש' DISPLAY;
384 define table_name / 'שם טבלה' DISPLAY;
385 define Nr_Rows / 'כלל יישויות *CCHIVE' DISPLAY f=comma32.;
386 define NR_Nulls / 'ציון כא * ריק' DISPLAY f=comma32.;
387 define NR_POS_Ad1 / 'ציון כא * חיובי קטן שווה 1' DISPLAY f=comma32.;
388 define NR_POS_MAAL1 / 'ציון כא * גדול מ1' DISPLAY f=comma32.;
389 define NR_NEG / 'ציון כא * שלילי' DISPLAY f=comma32.;
390 define NR_0/ 'ציון כא * 0' DISPLAY f=comma32.;
391 compute IND_Prob;
392 if IND_Prob = 0 then
393 do;
394 call define (_col_,"style", "style={background=lightgreen}");
395 end;
396 else if IND_Prob =1 then
397 do;
398 call define (_col_,"style", "style={background=lightred}");
399 end;
400 endcomp;
401
402
403 compute NR_POS_MAAL1;
404 if _c7_ >0 then do;
405 call define ('_c7_',"style", "style={background=lightred}");
406 end;
407 endcomp;
408
409 compute NR_NEG;
410 if _c8_ >0 then do;
411 call define ('_c8_',"style", "style={background=lightred}");
412 end;
413 endcomp;
414
415 compute NR_0;
416 if _c9_ >0 then do;
417 call define ('_c9_',"style", "style={background=lightred}");
418 end;
419 endcomp;
420 Run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 41 observations read from the data set WORK.S1B.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.21 seconds
user cpu time 0.20 seconds
system cpu time 0.01 seconds
12 The SAS System 07:59 Monday, June 23, 2025
memory 6976.37k
OS Memory 46816.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 214 Switch Count 0
Page Faults 0
Page Reclaims 1438
Page Swaps 0
Voluntary Context Switches 20
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
421
422
423
424 /***Pelet S2---No pepper***/
425 /***Pelet S2---No pepper***/
426 /***Pelet S2---No pepper***/
427 proc sql noprint;
428 select NP_IND_Prob as Ind_NP_S2_lastMon into :Ind_NP_S2_lastMon
429 from S2
430 where mon=&last_mon_in_Report_YYMM1.
431 ;
432 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5327.03k
OS Memory 46544.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 215 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
433 %put Ind_NP_S2_lastMon=&Ind_NP_S2_lastMon.;
Ind_NP_S2_lastMon= 0
434
435 proc sql noprint;
436 select case when &Ind_NP_S2_lastMon.=1 then 'Red'
437 when max(NP_IND_Prob)=1 then 'Orange'
438 else 'Green'
439 end as Ind_Color_Sheet_NP_S2 into : Ind_Color_Sheet_NP_S2
440 from S2
441 ;
442 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5327.03k
13 The SAS System 07:59 Monday, June 23, 2025
OS Memory 46544.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 216 Switch Count 0
Page Faults 0
Page Reclaims 8
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
443 %put Ind_Color_Sheet_NP_S2=&Ind_Color_Sheet_NP_S2.;
Ind_Color_Sheet_NP_S2=Green
444
445
446 ods excel options (sheet_name='S2_NP_HELP'
447 sheet_interval="proc" /**One table in sheet***/
448 gridlines = 'yes'
449 tab_color="&Ind_Color_Sheet_NP_S2."
450 );
451 title;
452 title1 bold color=red height=5 font=simplex 'בקרת מספר יישויות לפי-כן/לא פרי קלין,כן/לא מנצלים בכא שנה אחרונה';
453 title2 bold color=red height=5 font=simplex 'אוכלוסייה-יישויות שאינן פפר';
454 title3 bold color=red height=5 font=simplex 'אינד להדלקה-הפרש בתמהיל מעל 3% מחודש קודם';
455 title4 bold color=black height=5 font=simplex 'בקרה זו הינה עזר בלבד ולא בקרה ישירה של ציון כא';
456 title5 bold color=black height=5 font=simplex 'בדיקת ניצול כא נעשית בשנה אחרונה';
457 proc report data=S2 missing nowd;
458 column
459 NP_IND_Prob
460 table_name
461 mon
462
463 ("מספר יישויות"
464 NP_nr_Y
465 NP_nr_PRE_CLEAN
466 NP_nr_PRE_CLEAN_CRD
467 NP_nr_PRE_CLEAN_NoCRD
468 NP_nr_NoPreClean)
469
470
471 ("תמהיל יישויות"
472 NP_Tamhil_PRE_CLEAN
473 NP_Tamhil_PRE_CLEAN_CRD
474 NP_Tamhil_PRE_CLEAN_NoCRD
475 NP_Tamhil_NoPreClean)
476
477
478 ("הפרש תמהיל מחודש קודם"
479 NP_Dif_Tamhil_PRE_CLEAN
480 NP_Dif_Tamhil_PRE_CLEAN_CRD
481 NP_Dif_Tamhil_PRE_CLEAN_NoCRD
482 NP_Dif_Tamhil_NoPreClean)
483 ;
484 define NP_IND_Prob / 'אינד להדלקה' DISPLAY;
485 define mon / 'חודש' DISPLAY;
486 define table_name / 'שם טבלה' DISPLAY;
487
14 The SAS System 07:59 Monday, June 23, 2025
488 define NP_nr_Y / 'מספר יישויות' DISPLAY f=comma32.;
489 define NP_nr_PRE_CLEAN / 'אוכלוסייה_מדורגת' DISPLAY f=comma32.;
490 define NP_nr_PRE_CLEAN_CRD / 'אוכלוסייה_מדורגת+קיים ניצול בכא' DISPLAY f=comma32.;
491 define NP_nr_PRE_CLEAN_NoCRD / 'אוכלוסייה_מדורגת+אין ניצול בכא' DISPLAY f=comma32.;
492 define NP_nr_NoPreClean / 'אוכלוסייה_לא_מדורגת' DISPLAY f=comma32.;
493
494 define NP_Tamhil_PRE_CLEAN / 'אוכלוסייה_מדורגת' DISPLAY;
495 define NP_Tamhil_PRE_CLEAN_CRD / 'אוכלוסייה_מדורגת+קיים ניצול בכא' DISPLAY;
496 define NP_Tamhil_PRE_CLEAN_NoCRD / 'אוכלוסייה_מדורגת+אין ניצול בכא' DISPLAY;
497 define NP_Tamhil_NoPreClean / 'אוכלוסייה_לא_מדורגת' DISPLAY;
498
499 define NP_Dif_Tamhil_PRE_CLEAN / 'אוכלוסייה_מדורגת' DISPLAY;
500 define NP_Dif_Tamhil_PRE_CLEAN_CRD / 'אוכלוסייה_מדורגת+קיים ניצול בכא' DISPLAY;
501 define NP_Dif_Tamhil_PRE_CLEAN_NoCRD / 'אוכלוסייה_מדורגת+אין ניצול בכא' DISPLAY;
502 define NP_Dif_Tamhil_NoPreClean / 'אוכלוסייה_לא_מדורגת' DISPLAY;
503
504 compute NP_IND_Prob;
505 if NP_IND_Prob = 0 then
506 do;
507 call define (_col_,"style", "style={background=lightgreen}");
508 end;
509 else if NP_IND_Prob =1 then
510 do;
511 call define (_col_,"style", "style={background=lightred}");
512 end;
513 endcomp;
514
515
516 compute NP_Dif_Tamhil_PRE_CLEAN;
517 if abs(_c13_ )>0.03 then do;
518 call define ('_c13_',"style", "style={background=lightyellow}");
519 call define ('_c9_',"style", "style={background=lightyellow}");
520 call define ('_c5_',"style", "style={background=lightyellow}");
521 end;
522 endcomp;
523
524 compute NP_Dif_Tamhil_PRE_CLEAN_CRD;
525 if abs(_c14_ )>0.03 then do;
526 call define ('_c14_',"style", "style={background=lighorange}");
527 call define ('_c10_',"style", "style={background=lighorange}");
528 call define ('_c6_',"style", "style={background=lighorange}");
529 end;
530 endcomp;
531
532 compute NP_Dif_Tamhil_PRE_CLEAN_NoCRD;
533 if abs(_c15_ )>0.03 then do;
534 call define ('_c15_',"style", "style={background=lightpink}");
535 call define ('_c11_',"style", "style={background=lightpink}");
536 call define ('_c7_',"style", "style={background=lightpink}");
537 end;
538 endcomp;
539
540 compute NP_Dif_Tamhil_NoPreClean;
541 if abs(_c16_ )>0.03 then do;
542 call define ('_c16_',"style", "style={background=lightpurple}");
543 call define ('_c12_',"style", "style={background=lightpurple}");
544 call define ('_c8_',"style", "style={background=lightpurple}");
545 end;
15 The SAS System 07:59 Monday, June 23, 2025
546 endcomp;
547 Run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
2 at 1:5 2 at 1:5 2 at 1:5 2 at 1:5
NOTE: There were 41 observations read from the data set WORK.S2.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.33 seconds
user cpu time 0.33 seconds
system cpu time 0.00 seconds
memory 7907.00k
OS Memory 47072.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 217 Switch Count 0
Page Faults 0
Page Reclaims 1489
Page Swaps 0
Voluntary Context Switches 19
Involuntary Context Switches 2
Block Input Operations 0
Block Output Operations 0
548
549
550
551
552 /***Pelet S2---pepper***/
553 /***Pelet S2---pepper***/
554 /***Pelet S2---pepper***/
555 proc sql noprint;
556 select P_IND_Prob as Ind_P_S2_lastMon into :Ind_P_S2_lastMon
557 from S2
558 where mon>=2502 AND mon=&last_mon_in_Report_YYMM1.
559 ;
560 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5326.12k
OS Memory 47056.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 218 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
561 %put Ind_P_S2_lastMon=&Ind_P_S2_lastMon.;
Ind_P_S2_lastMon= 0
562
16 The SAS System 07:59 Monday, June 23, 2025
563
564 proc sql noprint;
565 select case when &Ind_P_S2_lastMon.=1 then 'Red'
566 when max(P_IND_Prob)=1 then 'Orange'
567 else 'Green'
568 end as Ind_Color_Sheet_P_S2 into : Ind_Color_Sheet_P_S2
569 from S2
570 where mon>=2502
571 ;
572 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 5327.53k
OS Memory 47056.00k
Timestamp 06/23/2025 09:56:33 AM
Step Count 219 Switch Count 0
Page Faults 0
Page Reclaims 9
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
573 %put Ind_Color_Sheet_P_S2=&Ind_Color_Sheet_P_S2.;
Ind_Color_Sheet_P_S2=Orange
574
575
576
577 ods excel options (sheet_name='S2_P_HELP'
578 sheet_interval="proc" /**One table in sheet**/
579 absolute_column_width="13,25,13,13,13,13,13,13,13,13,13,13,13,13,13,13"
580 row_heights='30,16,20,20,20'
581 gridlines = 'yes'
582 tab_color="&Ind_Color_Sheet_P_S2."
583 );
584
585
586 title;
587 title1 bold color=red height=5 font=simplex 'בקרת מספר יישויות לפי-כן/לא אוכלוסייה מדורגת,כן/לא מנצלים בכא שנה
587 ! אחרונה';
588 title2 bold color=red height=5 font=simplex 'אוכלוסייה-יישויות פפר';
589 title3 bold color=red height=5 font=simplex 'אינד להדלקה-הפרש בתמהיל מעל 3% מחודש קודם';
590 title4 bold color=red height=5 font=simplex 'הדלקת גליון-החל מ 2502 בגלל שזה פפר';
591 title5 bold color=black height=5 font=simplex 'בקרה זו הינה עזר בלבד ולא בקרה ישירה של ציון כא';
592 title6 bold color=black height=5 font=simplex 'בדיקת ניצול כא נעשית בשנה אחרונה';
593 proc report data=S2 missing nowd;
594 column
595 P_IND_Prob
596 table_name
597 mon
598
599 ("מספר יישויות"
600 P_nr_Y
601 P_nr_PRE_CLEAN
17 The SAS System 07:59 Monday, June 23, 2025
602 P_nr_PRE_CLEAN_CRD
603 P_nr_PRE_CLEAN_NoCRD
604 P_nr_NoPreClean)
605
606
607 ("תמהיל יישויות"
608 P_Tamhil_PRE_CLEAN
609 P_Tamhil_PRE_CLEAN_CRD
610 P_Tamhil_PRE_CLEAN_NoCRD
611 P_Tamhil_NoPreClean)
612
613
614 ("הפרש תמהיל מחודש קודם"
615 P_Dif_Tamhil_PRE_CLEAN
616 P_Dif_Tamhil_PRE_CLEAN_CRD
617 P_Dif_Tamhil_PRE_CLEAN_NoCRD
618 P_Dif_Tamhil_NoPreClean)
619 ;
620 define P_IND_Prob / 'אינד להדלקה' DISPLAY;
621 define mon / 'חודש' DISPLAY;
622 define table_name / 'שם טבלה' DISPLAY;
623
624 define P_nr_Y / 'מספר יישויות' DISPLAY f=comma32. style(column)={just=l};
625 define P_nr_PRE_CLEAN / 'אוכלוסייה_מדורגת' DISPLAY f=comma32. style(column)={just=l};
626 define P_nr_PRE_CLEAN_CRD / 'אוכלוסייה_מדורגת+קיים ניצול בכא' DISPLAY f=comma32. style(column)={just=l};
627 define P_nr_PRE_CLEAN_NoCRD / 'אוכלוסייה_מדורגת+אין ניצול בכא' DISPLAY f=comma32. style(column)={just=l};
628 define P_nr_NoPreClean / 'אוכלוסייה_לא_מדורגת' DISPLAY f=comma32. style(column)={just=l};
629
630 define P_Tamhil_PRE_CLEAN / 'אוכלוסייה_מדורגת' DISPLAY style(column)={just=l};
631 define P_Tamhil_PRE_CLEAN_CRD / 'אוכלוסייה_מדורגת+קיים ניצול בכא' DISPLAY style(column)={just=l};
632 define P_Tamhil_PRE_CLEAN_NoCRD / 'אוכלוסייה_מדורגת+אין ניצול בכא' DISPLAY style(column)={just=l};
633 define P_Tamhil_NoPreClean / 'אוכלוסייה_לא_מדורגת' DISPLAY style(column)={just=l};
634
635 define P_Dif_Tamhil_PRE_CLEAN / 'אוכלוסייה_מדורגת' DISPLAY style(column)={just=l};
636 define P_Dif_Tamhil_PRE_CLEAN_CRD / 'אוכלוסייה_מדורגת+קיים ניצול בכא' DISPLAY style(column)={just=l};
637 define P_Dif_Tamhil_PRE_CLEAN_NoCRD / 'אוכלוסייה_מדורגת+אין ניצול בכא' DISPLAY style(column)={just=l};
638 define P_Dif_Tamhil_NoPreClean / 'אוכלוסייה_לא_מדורגת' DISPLAY style(column)={just=l};
639
640 compute P_IND_Prob;
641 if P_IND_Prob = 0 then
642 do;
643 call define (_col_,"style", "style={background=lightgreen}");
644 end;
645 else if P_IND_Prob =1 then
646 do;
647 call define (_col_,"style", "style={background=lightred}");
648 end;
649 endcomp;
650
651
652 compute P_Dif_Tamhil_PRE_CLEAN;
653 if abs(_c13_ )>0.03 then do;
654 call define ('_c13_',"style", "style={background=lightyellow}");
655 call define ('_c9_',"style", "style={background=lightyellow}");
656 call define ('_c5_',"style", "style={background=lightyellow}");
657 end;
658 endcomp;
659
18 The SAS System 07:59 Monday, June 23, 2025
660 compute P_Dif_Tamhil_PRE_CLEAN_CRD;
661 if abs(_c14_ )>0.03 then do;
662 call define ('_c14_',"style", "style={background=lighorange}");
663 call define ('_c10_',"style", "style={background=lighorange}");
664 call define ('_c6_',"style", "style={background=lighorange}");
665 end;
666 endcomp;
667
668 compute P_Dif_Tamhil_PRE_CLEAN_NoCRD;
669 if abs(_c15_ )>0.03 then do;
670 call define ('_c15_',"style", "style={background=lightpink}");
671 call define ('_c11_',"style", "style={background=lightpink}");
672 call define ('_c7_',"style", "style={background=lightpink}");
673 end;
674 endcomp;
675
676 compute P_Dif_Tamhil_NoPreClean;
677 if abs(_c16_ )>0.03 then do;
678 call define ('_c16_',"style", "style={background=lightpurple}");
679 call define ('_c12_',"style", "style={background=lightpurple}");
680 call define ('_c8_',"style", "style={background=lightpurple}");
681 end;
682 endcomp;
683 Run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
2 at 1:5 2 at 1:5 2 at 1:5 2 at 1:5
NOTE: There were 41 observations read from the data set WORK.S2.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.32 seconds
user cpu time 0.32 seconds
system cpu time 0.00 seconds
memory 7826.31k
OS Memory 47328.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 220 Switch Count 0
Page Faults 0
Page Reclaims 1390
Page Swaps 0
Voluntary Context Switches 21
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
684
685
686
687 /***Pelet S3--No pepper****/
688 /***Pelet S3--No pepper****/
689 /***Pelet S3--No pepper****/
690 proc sql noprint;
691 select max(NP_IND_Prob) as Ind_NP_S3_lastMon into :Ind_NP_S3_lastMon
692 from NP_S3
693 where mon=&last_mon_in_Report_YYMM1.
694 ;
19 The SAS System 07:59 Monday, June 23, 2025
695 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 5320.59k
OS Memory 47312.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 221 Switch Count 0
Page Faults 0
Page Reclaims 9
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
696 %put Ind_NP_S3_lastMon=&Ind_NP_S3_lastMon.;
Ind_NP_S3_lastMon= 0
697
698
699 proc sql noprint;
700 select case when &Ind_NP_S3_lastMon.=1 then 'Red'
701 when max(NP_IND_Prob)=1 then 'Orange'
702 else 'Green'
703 end as Ind_Color_Sheet_NP_S3 into : Ind_Color_Sheet_NP_S3
704 from NP_S3
705 ;
706 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5319.21k
OS Memory 47312.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 222 Switch Count 1
Page Faults 0
Page Reclaims 8
Page Swaps 0
Voluntary Context Switches 2
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
707 %put Ind_Color_Sheet_NP_S3=&Ind_Color_Sheet_NP_S3.;
Ind_Color_Sheet_NP_S3=Green
708
709
710 proc format;
711 value red_fmt
712 1=lightred
713 other=lightgreen;
NOTE: Format RED_FMT is already on the library WORK.FORMATS.
NOTE: Format RED_FMT has been output.
714 run;
20 The SAS System 07:59 Monday, June 23, 2025
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 95.62k
OS Memory 42188.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 223 Switch Count 0
Page Faults 0
Page Reclaims 1
Page Swaps 0
Voluntary Context Switches 5
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
715
716 proc format;
717 value red2_fmt
718 1=lightorange
719 other=white;
NOTE: Format RED2_FMT is already on the library WORK.FORMATS.
NOTE: Format RED2_FMT has been output.
720 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 95.62k
OS Memory 42188.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 224 Switch Count 0
Page Faults 0
Page Reclaims 1
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
721
722
723 ods excel options(sheet_name="S3-NP"
724 embedded_titles='yes'
725 sheet_interval="none" /**Multiple tables in sheet***/
726 tab_color="&Ind_Color_Sheet_NP_S3."
727 );
728 /**Here multiple reports in same sheet***/
729 title;
730 title1 j=l bold color=red height=5 font=simplex 'אוכלוסייה-יישויות פרי_קלין שאינן פפר';
731 title2 j=l bold color=red height=5 font=simplex 'בקרת אוכלוסיה של דוד';
732 title3 j=l bold color=red height=5 font=simplex 'קריטריון להדלקה- שינוי לפחות 3% בתמהיל יישויות בכל אחת מהקבוצות לפי
732 ! אינטראקציה של-קיום ניצול בכא בשנה אחרונה,ציון כא חיובי או ריק ';
733 title4 j=l bold color=black height=5 font=simplex 'מטרה--בדיקה שהאוכ של דוד נכונה';
21 The SAS System 07:59 Monday, June 23, 2025
734 title5 j=l bold color=black height=5 font=simplex 'כלומר שהוא נותן ציון כא חיובי למנצלים בכא ונותן ציון כא ריק
734 ! ללקוחות שלא מנצלים בכא';
735 title6 j=l 'אינד להדלקה';
736 proc report data=NP_S3 missing nowd split='*'
737 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
738 columns Ind_CRD_12Mon _prev_mx_pos_prob_ Ind_Stira NP_IND_Prob,mon;
739 define Ind_CRD_12Mon/group 'אינד לקיום *ניצול כא';
740 define _prev_mx_pos_prob_/group 'אינד ציון כא *חיובי או ריק';
741 define Ind_Stira/group 'אינד לסתירה';
742 define mon/across order=data ' ';
743 define NP_IND_Prob/mean 'אינד להדלקה';
744 compute NP_IND_Prob;
745 call define(_col_,"Style","style={background=red_fmt.}");
746 endcomp;
747 compute Ind_Stira;
748 call define(_col_,"Style","style={background=red2_fmt.}");
749 endcomp;
750 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 164 observations read from the data set WORK.NP_S3.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.17 seconds
user cpu time 0.16 seconds
system cpu time 0.01 seconds
memory 9022.40k
OS Memory 49632.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 225 Switch Count 0
Page Faults 0
Page Reclaims 1890
Page Swaps 0
Voluntary Context Switches 38
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
751
752 title;
753 title j=l 'מספר יישויות';
754 proc report data=NP_S3 missing nowd split='*'
755 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
756 columns Ind_CRD_12Mon _prev_mx_pos_prob_ Ind_Stira NP_nr,mon;
757 define Ind_CRD_12Mon/group 'אינד לקיום *ניצול כא';
758 define _prev_mx_pos_prob_/group 'אינד ציון כא *חיובי או ריק';
759 define Ind_Stira/group 'אינד לסתירה';
760 define mon/across order=data ' ';
761 define NP_nr/mean 'מספר יישויות' f=comma32.;
762 compute Ind_Stira;
763 call define(_col_,"Style","style={background=red2_fmt.}");
764 endcomp;
765 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 164 observations read from the data set WORK.NP_S3.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
22 The SAS System 07:59 Monday, June 23, 2025
user cpu time 0.14 seconds
system cpu time 0.01 seconds
memory 8769.09k
OS Memory 49888.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 226 Switch Count 2
Page Faults 0
Page Reclaims 1727
Page Swaps 0
Voluntary Context Switches 35
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
766
767
768 title;
769 title j=l 'תמהיל יישויות';
770 proc report data=NP_S3 missing nowd split='*'
771 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
772 columns Ind_CRD_12Mon _prev_mx_pos_prob_ Ind_Stira NP_Tamhil,mon;
773 define Ind_CRD_12Mon/group 'אינד לקיום *ניצול כא';
774 define _prev_mx_pos_prob_/group 'אינד ציון כא *חיובי או ריק';
775 define Ind_Stira/group 'אינד לסתירה';
776 define mon/across order=data ' ';
777 define NP_Tamhil/mean 'תמהיל יישויות';
778 compute Ind_Stira;
779 call define(_col_,"Style","style={background=red2_fmt.}");
780 endcomp;
781 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 164 observations read from the data set WORK.NP_S3.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.12 seconds
user cpu time 0.12 seconds
system cpu time 0.00 seconds
memory 8766.25k
OS Memory 49888.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 227 Switch Count 2
Page Faults 0
Page Reclaims 1718
Page Swaps 0
Voluntary Context Switches 34
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
782
783 title;
784 title j=l 'הפרש בתמהיל יישויות מחודש קודם';
785 proc report data=NP_S3 missing nowd split='*'
786 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
787 columns Ind_CRD_12Mon _prev_mx_pos_prob_ Ind_Stira NP_dif_tamhil,mon;
788 define Ind_CRD_12Mon/group 'אינד לקיום *ניצול כא';
23 The SAS System 07:59 Monday, June 23, 2025
789 define _prev_mx_pos_prob_/group 'אינד ציון כא *חיובי או ריק';
790 define Ind_Stira/group 'אינד לסתירה';
791 define mon/across order=data ' ';
792 define NP_dif_tamhil/mean 'הפרש תמהיל יישויות';
793 compute Ind_Stira;
794 call define(_col_,"Style","style={background=red2_fmt.}");
795 endcomp;
796 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 164 observations read from the data set WORK.NP_S3.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.14 seconds
system cpu time 0.00 seconds
memory 8766.53k
OS Memory 49888.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 228 Switch Count 2
Page Faults 0
Page Reclaims 1722
Page Swaps 0
Voluntary Context Switches 34
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
797
798
799
800 /***Pelet S3--pepper****/
801 /***Pelet S3--pepper****/
802 /***Pelet S3--pepper****/
803 proc sql noprint;
804 select max(P_IND_Prob) as Ind_P_S3_lastMon into :Ind_P_S3_lastMon
805 from P_S3
806 where mon=&last_mon_in_Report_YYMM1. and mon>=2502
807 ;
808 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5321.50k
OS Memory 48080.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 229 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
809 %put Ind_P_S3_lastMon=&Ind_P_S3_lastMon.;
24 The SAS System 07:59 Monday, June 23, 2025
Ind_P_S3_lastMon= 0
810
811
812 proc sql noprint;
813 select case when &Ind_P_S3_lastMon.=1 then 'Red'
814 when max(P_IND_Prob)=1 then 'Orange'
815 else 'Green'
816 end as Ind_Color_Sheet_P_S3 into : Ind_Color_Sheet_P_S3
817 from P_S3
818 where mon>=2502
819 ;
820 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5321.50k
OS Memory 48080.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 230 Switch Count 0
Page Faults 0
Page Reclaims 9
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
821 %put Ind_Color_Sheet_P_S3=&Ind_Color_Sheet_P_S3.;
Ind_Color_Sheet_P_S3=Orange
822
823
824 proc format;
825 value red_fmt
826 1=lightred
827 other=lightgreen;
NOTE: Format RED_FMT is already on the library WORK.FORMATS.
NOTE: Format RED_FMT has been output.
828 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 95.62k
OS Memory 42956.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 231 Switch Count 0
Page Faults 0
Page Reclaims 1
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
25 The SAS System 07:59 Monday, June 23, 2025
829
830 proc format;
831 value red2_fmt
832 1=lightorange
833 other=white;
NOTE: Format RED2_FMT is already on the library WORK.FORMATS.
NOTE: Format RED2_FMT has been output.
834 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 95.78k
OS Memory 42956.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 232 Switch Count 0
Page Faults 0
Page Reclaims 1
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
835
836
837
838
839 /**Dummy code will not print anyting**/
840 /***We must put it between 2 none***/
841 ods select none;
842 ods excel options( sheet_interval="proc");
843 proc print data=sashelp.class;run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 352.31k
OS Memory 42956.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 233 Switch Count 0
Page Faults 0
Page Reclaims 44
Page Swaps 0
Voluntary Context Switches 5
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
844 ods select all;
845
846
847 ods excel options(sheet_name="S3-P"
26 The SAS System 07:59 Monday, June 23, 2025
848 embedded_titles='yes'
849 sheet_interval="none" /**Multiple tables in sheet***/
850 tab_color="&Ind_Color_Sheet_P_S3."
851 );
852 /**Here multiple reports in same sheet***/
853
854
855 title;
856 title1 j=l bold color=red height=5 font=simplex 'אוכלוסייה-יישויות פרי_קלין_פפר';
857 title2 j=l bold color=red height=5 font=simplex 'בקרת אוכלוסיה של דוד';
858 title3 j=l bold color=red height=5 font=simplex 'קריטריון להדלקה- שינוי לפחות 3% בתמהיל יישויות בכל אחת מהקבוצות
858 ! לפי-קיום ניצול בכא בשנה אחרונה,ציון כא חיובי או ריק ';
859 title4 j=l bold color=red height=5 font=simplex 'הדלקת גליון-החל מ 2502 בגלל שזה פפר';
860 title5 j=l bold color=black height=5 font=simplex 'מטרה--בדיקה שהאוכ של דוד נכונה';
861 title6 j=l bold color=black height=5 font=simplex 'כלומר שהוא נותן ציון כא חיובי למנצלים בכא ונותן ציון כא ריק
861 ! ללקוחות שלא מנצלים בכא';
862 title7 j=l 'אינד להדלקה';
863 proc report data=P_S3 missing nowd split='*'
864 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
865 columns Ind_CRD_12Mon _prev_mx_pos_prob_ Ind_Stira P_IND_Prob,mon;
866 define Ind_CRD_12Mon/group 'אינד לקיום *ניצול כא';
867 define _prev_mx_pos_prob_/group 'אינד ציון כא *חיובי או ריק';
868 define Ind_Stira/group 'אינד לסתירה';
869 define mon/across order=data ' ';
870 define P_IND_Prob/mean 'אינד להדלקה';
871 compute P_IND_Prob;
872 call define(_col_,"Style","style={background=red_fmt.}");
873 endcomp;
874 compute Ind_Stira;
875 call define(_col_,"Style","style={background=red2_fmt.}");
876 endcomp;
877 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 164 observations read from the data set WORK.P_S3.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.15 seconds
user cpu time 0.14 seconds
system cpu time 0.01 seconds
memory 8959.54k
OS Memory 49888.00k
Timestamp 06/23/2025 09:56:34 AM
Step Count 234 Switch Count 0
Page Faults 0
Page Reclaims 1743
Page Swaps 0
Voluntary Context Switches 32
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
878
879 title;
880 title j=l 'מספר יישויות';
881 proc report data=P_S3 missing nowd split='*'
882 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
883 columns Ind_CRD_12Mon _prev_mx_pos_prob_ Ind_Stira P_nr,mon;
27 The SAS System 07:59 Monday, June 23, 2025
884 define Ind_CRD_12Mon/group 'אינד לקיום *ניצול כא';
885 define _prev_mx_pos_prob_/group 'אינד ציון כא *חיובי או ריק';
886 define Ind_Stira/group 'אינד לסתירה';
887 define mon/across order=data ' ';
888 define P_nr/mean 'מספר יישויות' f=comma32.;
889 compute Ind_Stira;
890 call define(_col_,"Style","style={background=red2_fmt.}");
891 endcomp;
892 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 164 observations read from the data set WORK.P_S3.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.12 seconds
user cpu time 0.12 seconds
system cpu time 0.01 seconds
memory 8769.31k
OS Memory 50144.00k
Timestamp 06/23/2025 09:56:35 AM
Step Count 235 Switch Count 2
Page Faults 0
Page Reclaims 1744
Page Swaps 0
Voluntary Context Switches 36
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
893
894
895 title;
896 title j=l 'תמהיל יישויות';
897 proc report data=P_S3 missing nowd split='*'
898 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
899 columns Ind_CRD_12Mon _prev_mx_pos_prob_ Ind_Stira P_Tamhil,mon;
900 define Ind_CRD_12Mon/group 'אינד לקיום *ניצול כא';
901 define _prev_mx_pos_prob_/group 'אינד ציון כא *חיובי או ריק';
902 define Ind_Stira/group 'אינד לסתירה';
903 define mon/across order=data ' ';
904 define P_Tamhil/mean 'תמהיל יישויות';
905 compute Ind_Stira;
906 call define(_col_,"Style","style={background=red2_fmt.}");
907 endcomp;
908 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 164 observations read from the data set WORK.P_S3.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.13 seconds
user cpu time 0.13 seconds
system cpu time 0.01 seconds
memory 8766.37k
OS Memory 50144.00k
Timestamp 06/23/2025 09:56:35 AM
Step Count 236 Switch Count 2
Page Faults 0
Page Reclaims 1733
28 The SAS System 07:59 Monday, June 23, 2025
Page Swaps 0
Voluntary Context Switches 28
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
909
910 title;
911 title j=l 'הפרש בתמהיל יישויות מחודש קודם';
912 proc report data=P_S3 missing nowd split='*'
913 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
914 columns Ind_CRD_12Mon _prev_mx_pos_prob_ Ind_Stira P_dif_tamhil,mon;
915 define Ind_CRD_12Mon/group 'אינד לקיום *ניצול כא';
916 define _prev_mx_pos_prob_/group 'אינד ציון כא *חיובי או ריק';
917 define Ind_Stira/group 'אינד לסתירה';
918 define mon/across order=data ' ';
919 define P_dif_tamhil/mean 'הפרש תמהיל יישויות';
920 compute Ind_Stira;
921 call define(_col_,"Style","style={background=red2_fmt.}");
922 endcomp;
923 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 164 observations read from the data set WORK.P_S3.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.13 seconds
user cpu time 0.13 seconds
system cpu time 0.01 seconds
memory 8764.46k
OS Memory 50144.00k
Timestamp 06/23/2025 09:56:35 AM
Step Count 237 Switch Count 2
Page Faults 0
Page Reclaims 1731
Page Swaps 0
Voluntary Context Switches 30
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
924
925
926
927 /*****Pelet S4--No pepper****/
928 /*****Pelet S4--No pepper****/
929 /*****Pelet S4--No pepper****/
930 proc sql noprint;
931 select NP_IND_Prob as Ind_NP_S4_lastMon into :Ind_NP_S4_lastMon
932 from NP_S4
933 where mon=&last_mon_in_Report_YYMM1.
934 ;
935 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
29 The SAS System 07:59 Monday, June 23, 2025
memory 5325.21k
OS Memory 48080.00k
Timestamp 06/23/2025 09:56:35 AM
Step Count 238 Switch Count 0
Page Faults 0
Page Reclaims 5
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
936 %put Ind_NP_S4_lastMon=&Ind_NP_S4_lastMon.;
Ind_NP_S4_lastMon= 0
937
938
939 proc sql noprint;
940 select case when &Ind_NP_S4_lastMon.=1 then 'Red'
941 when max(NP_IND_Prob)=1 then 'Orange'
942 else 'Green'
943 end as Ind_Color_Sheet_NP_S4 into : Ind_Color_Sheet_NP_S4
944 from NP_S4
945 ;
946 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5325.21k
OS Memory 48080.00k
Timestamp 06/23/2025 09:56:35 AM
Step Count 239 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
947 %put Ind_Color_Sheet_NP_S4=&Ind_Color_Sheet_NP_S4.;
Ind_Color_Sheet_NP_S4=Green
948
949
950 ods excel options (sheet_name='S4-NP'
951 sheet_interval="proc" /**One table in sheet***/
952 absolute_column_width="12,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8"
953 row_heights='30,16,20,20,20'
954 tab_color="&Ind_Color_Sheet_NP_S4."
955 );
956 title;
957 title1 bold color=red height=5 font=simplex 'אוכ-יישויות שאינן פפר בעלות ציון כא חיובי';
958 title2 bold color=red height=5 font=simplex 'Percentiles בדיקת יציבות אחוזונים';
959 title3 bold color=red height=5 font=simplex 'קריטריון להדלקה- קפיצה מעל 5% כלומר מעל 0.05 בערך האחוזון מחודש קודם';
960 title4 bold color=black height=5 font=simplex 'בודקים הפרש בערכי אחוזונים בכל חודש מחודש קודם';
961 title5 bold color=black height=5 font=simplex 'כלומר בודקים דלתא בערך האחוזון מחודש לחודש קודם';
30 The SAS System 07:59 Monday, June 23, 2025
962 proc report data=NP_S4 missing nowd
963 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
964 column
965 NP_IND_Prob
966 mon
967 ("אחוזון_Percentiles"
968 P10
969 P20
970 P30
971 P40
972 P50
973 P60
974 P70
975 P80
976 P90
977 P95
978 P100
979 )
980 ("הפרש_באחוזון מחודש קודם"
981 dif_p10
982 dif_p20
983 dif_p30
984 dif_p40
985 dif_p50
986 dif_p60
987 dif_p70
988 dif_p80
989 dif_p90
990 dif_p95
991 dif_p100
992 )
993 ;
994 define NP_IND_Prob/DISPLAY 'אינד להדלקה';
995 define mon/DISPLAY 'חודש' ;
996 define P10/DISPLAY '10' f=8.2 ;
997 define P20/DISPLAY '20' f=8.2;
998 define P30/DISPLAY '30' f=8.2;
999 define P40/DISPLAY '40' f=8.2;
1000 define P50/DISPLAY '50' f=8.2;
1001 define P60/DISPLAY '60' f=8.2;
1002 define P70/DISPLAY '70' f=8.2;
1003 define P80/DISPLAY '80' f=8.2;
1004 define P90/DISPLAY '90' f=8.2;
1005 define P95/DISPLAY '95' f=8.2;
1006 define P100/DISPLAY '100' f=8.2;
1007 define dif_p10/DISPLAY '10' f=8.3;
1008 define dif_p20/DISPLAY '20' f=8.3;
1009 define dif_p30/DISPLAY '30' f=8.3;
1010 define dif_p40/DISPLAY '40' f=8.3 ;
1011 define dif_p50/DISPLAY '50' f=8.3 ;
1012 define dif_p60/DISPLAY '60' f=8.3;
1013 define dif_p70/DISPLAY '70' f=8.3;
1014 define dif_p80/DISPLAY '80' f=8.3;
1015 define dif_p90/DISPLAY '90' f=8.3;
1016 define dif_p95/DISPLAY '95' f=8.3;
1017 define dif_p100/DISPLAY '100' f=8.3;
1018 compute NP_IND_Prob;
1019 if NP_IND_Prob = 0 then
31 The SAS System 07:59 Monday, June 23, 2025
1020 do;
1021 call define (_col_,"style", "style={background=lightgreen}");
1022 end;
1023 else if NP_IND_Prob =1 then
1024 do;
1025 call define (_col_,"style", "style={background=lightred}");
1026 end;
1027 endcomp;
1028
1029
1030 compute dif_p10;
1031 if _c14_ >0.05 then do;
1032 call define ('_c14_',"style", "style={background=lighyellow}");
1033 call define ('_c3_',"style", "style={background=lighyellow}");
1034 end;
1035 endcomp;
1036
1037 compute dif_p20;
1038 if _c15_ >0.05 then do;
1039 call define ('_c15_',"style", "style={background=lighorange}");
1040 call define ('_c4_',"style", "style={background=lighorange}");
1041 end;
1042 endcomp;
1043
1044 compute dif_p30;
1045 if _c16_ >0.05 then do;
1046 call define ('_c16_',"style", "style={background=lightblue}");
1047 call define ('_c5_',"style", "style={background=lighorange}");
1048 end;
1049 endcomp;
1050
1051 compute dif_p40;
1052 if _c17_ >0.05 then do;
1053 call define ('_c17_',"style", "style={background=lightpink}");
1054 call define ('_c6_',"style", "style={background=lightpink}");
1055 end;
1056 endcomp;
1057
1058
1059 compute dif_p50;
1060 if _c18_ >0.05 then do;
1061 call define ('_c18_',"style", "style={background=lightgrey}");
1062 call define ('_c7_',"style", "style={background=lightgrey}");
1063 end;
1064 endcomp;
1065
1066 compute dif_p60;
1067 if _c19_ >0.05 then do;
1068 call define ('_c19_',"style", "style={background=lightbrown}");
1069 call define ('_c8_',"style", "style={background=lightbrown}");
1070 end;
1071 endcomp;
1072
1073
1074 compute dif_p70;
1075 if _c20_ >0.05 then do;
1076 call define ('_c20_',"style", "style={background=yelow}");
1077 call define ('_c9_',"style", "style={background=yelow}");
32 The SAS System 07:59 Monday, June 23, 2025
1078 end;
1079 endcomp;
1080
1081 compute dif_p80;
1082 if _c21_ >0.05 then do;
1083 call define ('_c21_',"style", "style={background=red}");
1084 call define ('_c10_',"style", "style={background=red}");
1085 end;
1086 endcomp;
1087
1088 compute dif_p90;
1089 if _c22_ >0.05 then do;
1090 call define ('_c22_',"style", "style={background=blue}");
1091 call define ('_c11_',"style", "style={background=blue}");
1092 end;
1093 endcomp;
1094
1095
1096 compute dif_p95;
1097 if _c23_ >0.05 then do;
1098 call define ('_c23_',"style", "style={background=pink}");
1099 call define ('_c12_',"style", "style={background=pink}");
1100 end;
1101 endcomp;
1102
1103
1104 compute dif_p100;
1105 if _c24_ >0.05 then do;
1106 call define ('_c24_',"style", "style={background=orange}");
1107 call define ('_c13_',"style", "style={background=orange}");
1108 end;
1109 endcomp;
1110 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 41 observations read from the data set WORK.NP_S4.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.47 seconds
user cpu time 0.46 seconds
system cpu time 0.02 seconds
memory 9454.31k
OS Memory 50144.00k
Timestamp 06/23/2025 09:56:35 AM
Step Count 240 Switch Count 0
Page Faults 0
Page Reclaims 1791
Page Swaps 0
Voluntary Context Switches 19
Involuntary Context Switches 5
Block Input Operations 0
Block Output Operations 0
1111
1112
1113
1114 /*****Pelet S4--pepper****/
1115 /*****Pelet S4--pepper****/
33 The SAS System 07:59 Monday, June 23, 2025
1116 /*****Pelet S4--pepper****/
1117 proc sql noprint;
1118 select P_IND_Prob as Ind_P_S4_lastMon into :Ind_P_S4_lastMon
1119 from P_S4
1120 where mon=&last_mon_in_Report_YYMM1. and mon>=2502
1121 ;
1122 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5326.46k
OS Memory 48336.00k
Timestamp 06/23/2025 09:56:35 AM
Step Count 241 Switch Count 0
Page Faults 0
Page Reclaims 5
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1123 %put Ind_P_S4_lastMon=&Ind_P_S4_lastMon.;
Ind_P_S4_lastMon= 1
1124
1125
1126 proc sql noprint;
1127 select case when &Ind_P_S4_lastMon.=1 then 'Red'
1128 when max(P_IND_Prob)=1 then 'Orange'
1129 else 'Green'
1130 end as Ind_Color_Sheet_P_S4 into : Ind_Color_Sheet_P_S4
1131 from P_S4
1132 where mon>=2502
1133 ;
1134 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5327.87k
OS Memory 48336.00k
Timestamp 06/23/2025 09:56:35 AM
Step Count 242 Switch Count 0
Page Faults 0
Page Reclaims 8
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1135 %put Ind_Color_Sheet_P_S4=&Ind_Color_Sheet_P_S4.;
Ind_Color_Sheet_P_S4=Red
1136
1137
34 The SAS System 07:59 Monday, June 23, 2025
1138
1139 ods excel options (sheet_name='S4-P'
1140 sheet_interval="proc" /**One table in sheet***/
1141 absolute_column_width="12,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8"
1142 row_heights='30,16,20,20,20'
1143 tab_color="&Ind_Color_Sheet_P_S4."
1144 );
1145 title;
1146 title1 j=l bold color=red height=5 font=simplex 'אוכ-יישויות פפר בעלות ציון כא חיובי';
1147 title2 j=l bold color=red height=5 font=simplex 'Percentiles בדיקת יציבות אחוזונים';
1148 title3 j=l bold color=red height=5 font=simplex 'קריטריון להדלקה- קפיצה מעל 5% כלומר מעל 0.05 בערך האחוזון מחודש
1148 ! קודם';
1149 title4 j=l bold color=red height=5 font=simplex 'הדלקת גליון-החל מ 2502 בגלל שזה פפר';
1150 title5 j=l bold color=black height=5 font=simplex 'בודקים הפרש בערכי אחוזונים בכל חודש מחודש קודם';
1151 title6 j=l bold color=black height=5 font=simplex 'כלומר בודקים דלתא בערך האחוזון מחודש לחודש קודם';
1152 proc report data=P_S4 missing nowd
1153 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px} ;
1154 column
1155 P_IND_Prob
1156 mon
1157 ("אחוזון_Percentiles"
1158 P10
1159 P20
1160 P30
1161 P40
1162 P50
1163 P60
1164 P70
1165 P80
1166 P90
1167 P95
1168 P100
1169 )
1170 ("הפרש_באחוזון מחודש קודם"
1171 dif_p10
1172 dif_p20
1173 dif_p30
1174 dif_p40
1175 dif_p50
1176 dif_p60
1177 dif_p70
1178 dif_p80
1179 dif_p90
1180 dif_p95
1181 dif_p100
1182 )
1183 ;
1184 define P_IND_Prob/DISPLAY 'אינד להדלקה';
1185 define mon/DISPLAY 'חודש' ;
1186 define P10/DISPLAY '10' f=8.2 ;
1187 define P20/DISPLAY '20' f=8.2;
1188 define P30/DISPLAY '30' f=8.2;
1189 define P40/DISPLAY '40' f=8.2;
1190 define P50/DISPLAY '50' f=8.2;
1191 define P60/DISPLAY '60' f=8.2;
1192 define P70/DISPLAY '70' f=8.2;
1193 define P80/DISPLAY '80' f=8.2;
1194 define P90/DISPLAY '90' f=8.2;
35 The SAS System 07:59 Monday, June 23, 2025
1195 define P95/DISPLAY '95' f=8.2;
1196 define P100/DISPLAY '100' f=8.2;
1197 define dif_p10/DISPLAY '10' f=8.3 ;
1198 define dif_p20/DISPLAY '20' f=8.3 ;
1199 define dif_p30/DISPLAY '30' f=8.3 ;
1200 define dif_p40/DISPLAY '40' f=8.3 ;
1201 define dif_p50/DISPLAY '50' f=8.3 ;
1202 define dif_p60/DISPLAY '60' f=8.3;
1203 define dif_p70/DISPLAY '70' f=8.3;
1204 define dif_p80/DISPLAY '80' f=8.3;
1205 define dif_p90/DISPLAY '90' f=8.3;
1206 define dif_p95/DISPLAY '95' f=8.3;
1207 define dif_p100/DISPLAY '100' f=8.3;
1208 compute P_IND_Prob;
1209 if P_IND_Prob = 0 then
1210 do;
1211 call define (_col_,"style", "style={background=lightgreen}");
1212 end;
1213 else if P_IND_Prob =1 then
1214 do;
1215 call define (_col_,"style", "style={background=lightred}");
1216 end;
1217 endcomp;
1218
1219
1220 compute dif_p10;
1221 if _c14_ >0.05 then do;
1222 call define ('_c14_',"style", "style={background=lighyellow}");
1223 call define ('_c3_',"style", "style={background=lighyellow}");
1224 end;
1225 endcomp;
1226
1227 compute dif_p20;
1228 if _c15_ >0.05 then do;
1229 call define ('_c15_',"style", "style={background=lighorange}");
1230 call define ('_c4_',"style", "style={background=lighorange}");
1231 end;
1232 endcomp;
1233
1234 compute dif_p30;
1235 if _c16_ >0.05 then do;
1236 call define ('_c16_',"style", "style={background=lightblue}");
1237 call define ('_c5_',"style", "style={background=lighorange}");
1238 end;
1239 endcomp;
1240
1241 compute dif_p40;
1242 if _c17_ >0.05 then do;
1243 call define ('_c17_',"style", "style={background=lightpink}");
1244 call define ('_c6_',"style", "style={background=lightpink}");
1245 end;
1246 endcomp;
1247
1248
1249 compute dif_p50;
1250 if _c18_ >0.05 then do;
1251 call define ('_c18_',"style", "style={background=lightgrey}");
1252 call define ('_c7_',"style", "style={background=lightgrey}");
36 The SAS System 07:59 Monday, June 23, 2025
1253 end;
1254 endcomp;
1255
1256 compute dif_p60;
1257 if _c19_ >0.05 then do;
1258 call define ('_c19_',"style", "style={background=lightbrown}");
1259 call define ('_c8_',"style", "style={background=lightbrown}");
1260 end;
1261 endcomp;
1262
1263
1264 compute dif_p70;
1265 if _c20_ >0.05 then do;
1266 call define ('_c20_',"style", "style={background=yelow}");
1267 call define ('_c9_',"style", "style={background=yelow}");
1268 end;
1269 endcomp;
1270
1271 compute dif_p80;
1272 if _c21_ >0.05 then do;
1273 call define ('_c21_',"style", "style={background=red}");
1274 call define ('_c10_',"style", "style={background=red}");
1275 end;
1276 endcomp;
1277
1278 compute dif_p90;
1279 if _c22_ >0.05 then do;
1280 call define ('_c22_',"style", "style={background=blue}");
1281 call define ('_c11_',"style", "style={background=blue}");
1282 end;
1283 endcomp;
1284
1285
1286 compute dif_p95;
1287 if _c23_ >0.05 then do;
1288 call define ('_c23_',"style", "style={background=pink}");
1289 call define ('_c12_',"style", "style={background=pink}");
1290 end;
1291 endcomp;
1292
1293
1294 compute dif_p100;
1295 if _c24_ >0.05 then do;
1296 call define ('_c24_',"style", "style={background=orange}");
1297 call define ('_c13_',"style", "style={background=orange}");
1298 end;
1299 endcomp;
1300 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 41 observations read from the data set WORK.P_S4.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.50 seconds
user cpu time 0.49 seconds
system cpu time 0.01 seconds
memory 9334.54k
OS Memory 50400.00k
Timestamp 06/23/2025 09:56:36 AM
37 The SAS System 07:59 Monday, June 23, 2025
Step Count 243 Switch Count 0
Page Faults 0
Page Reclaims 1781
Page Swaps 0
Voluntary Context Switches 21
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1301
1302
1303
1304
1305 /***Pelet S5--Here no have crietria for problem***/
1306 /***Pelet S5--Here no have crietria for problem***/
1307 /***Pelet S5--Here no have crietria for problem***/
1308 proc format;
1309 value $hdfmt
1310 'לא_פפר'='cyan'
1311 'פפר'='cyan'
1312 ;
NOTE: Format $HDFMT has been output.
1313 Run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 100.09k
OS Memory 43724.00k
Timestamp 06/23/2025 09:56:36 AM
Step Count 244 Switch Count 0
Page Faults 0
Page Reclaims 5
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
1314
1315 ods excel options (sheet_name='S5_Help'
1316 sheet_interval="proc" /**One table in sheet**/
1317 absolute_column_width="13,25,15,15,15,15,15,15,15,15"
1318 row_heights='35,50,20,20,20'
1319 tab_color='grey'
1320 );
1321 title;
1322 title1 j=l bold color=red height=5 font=simplex 'אוכלוסייה--כלל יישויות קלין';
1323 title2 j=l bold color=red height=5 font=simplex 'בקרת טבלאות add.PANELCS_ZEL_YYMM_Y_CLEAN';
1324 title3 j=l bold color=red height=5 font=simplex 'בקרת אחוז יישויות בכשל 12 חודשים קדימה';
1325 title3 j=l bold color=red height=5 font=simplex 'לא הוגדר קריטריון להדלקה';
1326 title4 j=l bold color=black height=4 font=simplex 'הערה--- הטבלאות קיימות רק אם יש 12 חודשי מעקב קדימה שזמינים ';
1327 title5 j=l bold color=black height=4 font=simplex 'זוהי איננה בקרה ישירה לנושא ציון כא';
1328 proc report data=S5(Where=(Ind_Tbl_Exit=1)) missing nowd split='*'
1329 /*STYLE(Report) = {frame=box bordercolor = grey borderwidth=2px}*/
38 The SAS System 07:59 Monday, June 23, 2025
1330 /*STYLE(header) = HEADER{background=verylightgrey fontsize=2}*/
1331
1332 style(report)={frame=box font_size=8pt bordercolor=black borderwidth=2px}
1333 style(header)={font_weight=bold borderwidth=0 borderspacing=0 font_size=9pt background=$hdfmt. };
1334 ;
1335 column
1336 mon
1337 table_name
1338
1339 ("לא_פפר"
1340 NP_Nr_Y
1341 NP_nr_KESHELFUTURE
1342 NP_nr_NoKESHELFUTURE
1343 NP_PCT_KESHELFUTURE)
1344
1345 ("פפר"
1346 P_Nr_Y
1347 P_nr_KESHELFUTURE
1348 P_nr_NoKESHELFUTURE
1349 P_PCT_KESHELFUTURE)
1350 ;
1351 define mon/Display "חודש" style(header)=[background=lightblue] ;
1352 define table_name/Display "שם טבלה" style(header)=[background=lightblue];
1353
1354 define NP_Nr_Y/Display style(header)=[background=lightblue] 'מספר יישויות' f=comma32. ;
1355 define NP_nr_KESHELFUTURE/Display style(header)=[background=lightblue] 'מספר יישויות * בכשל' f=comma32. ;
1356 define NP_nr_NoKESHELFUTURE/Display style(header)=[background=lightblue] 'מספר יישויות * לא בכשל' f=comma32. ;
1357 define NP_PCT_KESHELFUTURE/Display style(header)=[background=lightblue] STYLE(column)=[just=c width=.6in] 'אחוז
1357 ! יישויות בכשל ' ;
1358
1359 define P_Nr_Y/Display style(header)=[background=lightblue] 'מספר יישויות ';
1360 define P_nr_KESHELFUTURE/Display style(header)=[background=lightblue] 'מספר יישויות * בכשל ' f=comma32. ;
1361 define P_nr_NoKESHELFUTURE/Display style(header)=[background=lightblue] 'מספר יישויות * לא בכשל' f=comma32. ;
1362 define P_PCT_KESHELFUTURE/Display style(header)=[background=lightblue] STYLE(column)=[just=c width=.6in] 'אחוז
1362 ! יישויות בכשל' ;
1363
1364
1365 COMPUTE NP_PCT_KESHELFUTURE;
1366 IF _col_ = 6 THEN DO;
1367 CALL DEFINE(_col_,'style','style={background=verylightyellow}');
1368 END;
1369 ENDCOMP;
1370
1371 COMPUTE P_PCT_KESHELFUTURE;
1372 IF _col_ = 10 THEN DO;
1373 CALL DEFINE(_col_,'style','style={background=verylightyellow}');
1374 END;
1375 ENDCOMP;
1376 Run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 24 observations read from the data set WORK.S5.
WHERE Ind_Tbl_Exit=1;
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.18 seconds
user cpu time 0.18 seconds
system cpu time 0.01 seconds
memory 7154.71k
39 The SAS System 07:59 Monday, June 23, 2025
OS Memory 48864.00k
Timestamp 06/23/2025 09:56:36 AM
Step Count 245 Switch Count 0
Page Faults 0
Page Reclaims 1336
Page Swaps 0
Voluntary Context Switches 33
Involuntary Context Switches 4
Block Input Operations 0
Block Output Operations 0
1377
1378
1379 /****Pelet S6---No pepper***/
1380 /****Pelet S6---No pepper***/
1381 /****Pelet S6---No pepper***/
1382 proc sql noprint;
1383 select Ind_prob_Ordinal as Ind_NP_S6_lastMon into :Ind_NP_S6_lastMon
1384 from NP_S6
1385 where mon=&last_mon_in_Report_YYMM2.
1386 ;
1387 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5321.53k
OS Memory 48848.00k
Timestamp 06/23/2025 09:56:36 AM
Step Count 246 Switch Count 0
Page Faults 0
Page Reclaims 6
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1388 %put Ind_NP_S6_lastMon=&Ind_NP_S6_lastMon.;
Ind_NP_S6_lastMon= 0
1389
1390
1391
1392
1393 proc sql noprint;
1394 select case when &Ind_NP_S6_lastMon.=1 then 'Red'
1395 when max(Ind_prob_Ordinal)=1 then 'Orange'
1396 else 'Green'
1397 end as Ind_Color_Sheet_NP_S6 into : Ind_Color_Sheet_NP_S6
1398 from NP_S6
1399 ;
1400 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
40 The SAS System 07:59 Monday, June 23, 2025
memory 5321.53k
OS Memory 48848.00k
Timestamp 06/23/2025 09:56:36 AM
Step Count 247 Switch Count 1
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1401 %put Ind_Color_Sheet_NP_S6=&Ind_Color_Sheet_NP_S6.;
Ind_Color_Sheet_NP_S6=Green
1402
1403
1404
1405 proc format;
1406 value redf 1=red
1407 other=lightgreen;
NOTE: Format REDF has been output.
1408 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 99.81k
OS Memory 43724.00k
Timestamp 06/23/2025 09:56:36 AM
Step Count 248 Switch Count 0
Page Faults 0
Page Reclaims 1
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1409
1410 ods excel options(sheet_name="S6A_NP"
1411 embedded_titles='yes'
1412 /*sheet_interval="proc" */
1413 sheet_interval="none" /*Multiple tables in sheet**/
1414 tab_color="&Ind_Color_Sheet_NP_S6."
1415 );
1416 /**Here multiple reports in same sheet***/
1417 title;
1418 title1 j=l bold color=red height=5 font=simplex 'אוכ-יישויות נקיות שאינן פפר';
1419 title2 j=l bold color=red height=5 font=simplex 'בדיקה1----בדיקת אורדינליות באחוז הכשל בקבוצות ציון כא';
1420 title3 j=l bold color=black height=4 font=simplex 'בדיקת אורדינליות נעשית ללא קטגוריית ערכים ריקים';
1421 title4 j=l bold color=red height=5 font=simplex 'קריטריון להדלקה- לא מתקיימת אורדינליות בין הקטגוריות של קבוצות ציון
1421 ! כא-ככל שעולים בקבוצה אחוז הכשל בקבוצה צריך לגדול';
1422 title4 j=l bold color=black height=4 font=simplex 'הערה:חודשים נחקרים הם חודשים שיש להם נתוני מעקב כשל של 12 חודשים
1422 ! קדימה';
1423 title5 j=l bold color=black height=4 font=simplex 'הערה:חלוקת ציון כא לקבוצות 0-10 10-20 20-30 30-40 40-50 50-60 60-70
41 The SAS System 07:59 Monday, June 23, 2025
1423 ! 70-80 80-90 90-100 וקבוצת ערכים ריקים';
1424 title6 j=l bold color=black height=4 font=simplex 'הערה:KESHEL_FUTURE---add.PANELCS_ZEL_YYMM_Y_CLEAN';
1425 title7 j=l bold color=black height=4 font=simplex 'הערה:ADD.EXTRAS_YYMM_CCHIVE-----prev_mx_pos_prob';
1426 title8 j=l 'פלט של טבלה אחת -פחות נוח לעבודה';
1427 proc report data=NP_S6;
1428 columns mon Ind_prob_Ordinal,CAT NP_PCT_ra,CAT NP_nr,CAT NP_nr_Ra,CAT;
1429 define mon/group descending;
1430 define CAT/across order=data ' ';
1431 compute Ind_prob_Ordinal;
1432 call define(_col_,"Style","style={background=redf.}");
1433 endcompute;
1434 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.54 seconds
user cpu time 0.54 seconds
system cpu time 0.01 seconds
memory 10739.93k
OS Memory 52448.00k
Timestamp 06/23/2025 09:56:37 AM
Step Count 249 Switch Count 0
Page Faults 0
Page Reclaims 2205
Page Swaps 0
Voluntary Context Switches 58
Involuntary Context Switches 5
Block Input Operations 0
Block Output Operations 0
1435
1436 title;
1437 title justify=left 'אינד להדלקה';
1438 proc report data=NP_S6;
1439 columns mon Ind_prob_Ordinal,CAT;
1440 define mon/group descending;
1441 define CAT/across order=data ' ';;
1442 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.14 seconds
system cpu time 0.01 seconds
memory 7426.59k
OS Memory 49888.00k
Timestamp 06/23/2025 09:56:37 AM
Step Count 250 Switch Count 2
Page Faults 0
Page Reclaims 1407
Page Swaps 0
Voluntary Context Switches 31
Involuntary Context Switches 0
Block Input Operations 0
42 The SAS System 07:59 Monday, June 23, 2025
Block Output Operations 0
1443
1444 title;
1445 title justify=left 'אחוז כשל בקבוצה';
1446 proc report data=NP_S6;
1447 columns mon NP_PCT_ra,CAT;
1448 define mon/group descending;
1449 define CAT/across order=data ' ';;
1450 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.14 seconds
system cpu time 0.01 seconds
memory 7406.28k
OS Memory 49632.00k
Timestamp 06/23/2025 09:56:37 AM
Step Count 251 Switch Count 2
Page Faults 0
Page Reclaims 1409
Page Swaps 0
Voluntary Context Switches 32
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1451
1452
1453 title;
1454 title justify=left 'מספר יישויות בקבוצה';
1455 proc report data=NP_S6;
1456 columns mon NP_nr,CAT;
1457 define mon/group descending;
1458 define CAT/across order=data ' ';;
1459 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.13 seconds
user cpu time 0.13 seconds
system cpu time 0.00 seconds
memory 7339.75k
OS Memory 49632.00k
Timestamp 06/23/2025 09:56:37 AM
Step Count 252 Switch Count 2
Page Faults 0
Page Reclaims 1425
Page Swaps 0
Voluntary Context Switches 29
Involuntary Context Switches 0
Block Input Operations 0
43 The SAS System 07:59 Monday, June 23, 2025
Block Output Operations 0
1460
1461
1462 title;
1463 title justify=left 'מספר יישויות בכשל בקבוצה';
1464 proc report data=NP_S6;
1465 columns mon NP_nr_Ra,CAT;
1466 define mon/group descending;
1467 define CAT/across order=data ' ';;
1468 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.13 seconds
user cpu time 0.13 seconds
system cpu time 0.00 seconds
memory 7453.68k
OS Memory 49888.00k
Timestamp 06/23/2025 09:56:37 AM
Step Count 253 Switch Count 2
Page Faults 0
Page Reclaims 1410
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1469
1470
1471 proc sql noprint;
1472 select case when max(NP_IND_Prob)=1 then 'Red' else 'Green' end as Ind_Color_Sheet_NP_S6b into : Ind_Color_Sheet_NP_S6b
1473 from NP_S6
1474 ;
1475 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 5321.25k
OS Memory 49360.00k
Timestamp 06/23/2025 09:56:37 AM
Step Count 254 Switch Count 1
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1476 %put Ind_Color_Sheet_NP_S6b=&Ind_Color_Sheet_NP_S6b.;
Ind_Color_Sheet_NP_S6b=Green
44 The SAS System 07:59 Monday, June 23, 2025
1477
1478
1479
1480
1481 /**Dummy code will not print anyting**/
1482 /***We must put it between 2 none***/
1483 ods select none;
1484 ods excel options( sheet_interval="proc");
1485 proc print data=sashelp.class;run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 347.71k
OS Memory 44236.00k
Timestamp 06/23/2025 09:56:37 AM
Step Count 255 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1486 ods select all;
1487
1488
1489
1490 ods excel options(sheet_name="S6B_NP"
1491 embedded_titles='yes'
1492 /*sheet_interval="proc" */
1493 sheet_interval="none" /**Multiple tables in sheet***/
1494 tab_color="&Ind_Color_Sheet_NP_S6b."
1495 );
1496 title;
1497 title1 j=l bold color=red height=5 font=simplex 'אוכ-יישויות נקיות שאינן פפר';
1498 title2 j=l bold color=red height=5 font=simplex 'בדיקה2-בדיקת יציבות במספר יישויות נקיות, מספר יישויות בכשל';
1499 title3 j=l bold color=red height=5 font=simplex 'הערה: קירטריון להדלקה שינוי של מעל 3% בתמהיל יישויות/תמהיל יישויות
1499 ! בכשל/אחוז כשל מחודש לחודש';
1500 title4 j=l 'IF abs(P_Delta_Tamhil_nr)>0.03 OR abs(P_Delta_PCT_ra)>0.03 OR abs(P_Delta_PCT_ra)>0.03 then P_IND_Prob=1';
1501 title5 j=l 'הערה- בודקים שינויים בתמהיל בין חודש לחודש קודם';
1502 title6 j=l 'הערה:חדשים נחקרים הם חודשים שיש להם נתוני מעקב כשל של 12 חודשים קדימה';
1503 title7 j=l 'פלט של טבלה אחת -פחות נוח לעבודה';
1504 proc report data=NP_S6;
1505 columns mon NP_IND_Prob,CAT NP_nr,CAT NP_nr_Ra,CAT NP_PCT_ra,CAT NP_Tamhil_nr,CAT NP_Tamhil_ra,CAT
1505 ! NP_Delta_PCT_ra,CAT NP_Delta_Tamhil_nr,CAT NP_Delta_Tamhil_ra,CAT;
1506 define mon/group descending;
1507 define CAT/across order=data ' ';;
1508 compute NP_IND_Prob;
1509 call define(_col_,"Style","style={background=redf.}");
1510 endcompute;
1511 run;
NOTE: Multiple concurrent threads will be used to summarize data.
45 The SAS System 07:59 Monday, June 23, 2025
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 1.09 seconds
user cpu time 1.08 seconds
system cpu time 0.03 seconds
memory 18089.82k
OS Memory 61408.00k
Timestamp 06/23/2025 09:56:38 AM
Step Count 256 Switch Count 0
Page Faults 0
Page Reclaims 9696
Page Swaps 0
Voluntary Context Switches 77
Involuntary Context Switches 3
Block Input Operations 0
Block Output Operations 0
1512
1513 title;
1514 title justify=left 'אינד להדלקה';
1515 proc report data=NP_S6;
1516 columns mon NP_IND_Prob,CAT;
1517 define mon/group descending;
1518 define CAT/across order=data ' ';;
1519 compute NP_IND_Prob;
1520 call define(_col_,"Style","style={background=redf.}");
1521 endcompute;
1522 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.18 seconds
user cpu time 0.17 seconds
system cpu time 0.01 seconds
memory 7624.28k
OS Memory 50912.00k
Timestamp 06/23/2025 09:56:38 AM
Step Count 257 Switch Count 2
Page Faults 0
Page Reclaims 2735
Page Swaps 0
Voluntary Context Switches 28
Involuntary Context Switches 2
Block Input Operations 0
Block Output Operations 0
1523
1524 title;
1525 title justify=left 'מספר יישויות';
1526 proc report data=NP_S6;
1527 columns mon NP_nr,CAT;
1528 define mon/group descending;
1529 define CAT/across order=internal ' ';;
1530 run;
46 The SAS System 07:59 Monday, June 23, 2025
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.16 seconds
user cpu time 0.17 seconds
system cpu time 0.00 seconds
memory 7372.65k
OS Memory 50912.00k
Timestamp 06/23/2025 09:56:39 AM
Step Count 258 Switch Count 2
Page Faults 0
Page Reclaims 1376
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1531
1532 title;
1533 title justify=left 'מספר יישויות בכשל';
1534 proc report data=NP_S6;
1535 columns mon NP_nr_Ra,CAT;
1536 define mon/group descending;
1537 define CAT/across order=internal ' ';;
1538 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.13 seconds
system cpu time 0.01 seconds
memory 7316.09k
OS Memory 50912.00k
Timestamp 06/23/2025 09:56:39 AM
Step Count 259 Switch Count 2
Page Faults 0
Page Reclaims 1357
Page Swaps 0
Voluntary Context Switches 28
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1539
1540
1541 title;
1542 title justify=left 'אחוז יישויות בכשל';
1543 proc report data=NP_S6;
1544 columns mon NP_PCT_ra,CAT;
1545 define mon/group descending;
1546 define CAT/across order=internal ' ';;
1547 run;
47 The SAS System 07:59 Monday, June 23, 2025
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.14 seconds
system cpu time 0.00 seconds
memory 7330.62k
OS Memory 50656.00k
Timestamp 06/23/2025 09:56:39 AM
Step Count 260 Switch Count 2
Page Faults 0
Page Reclaims 1365
Page Swaps 0
Voluntary Context Switches 23
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1548
1549
1550 title;
1551 title justify=left 'תמהיל יישויות';
1552 proc report data=NP_S6;
1553 columns mon NP_Tamhil_nr,CAT;
1554 define mon/group descending;
1555 define CAT/across order=internal ' ';;
1556 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.16 seconds
user cpu time 0.16 seconds
system cpu time 0.01 seconds
memory 7326.93k
OS Memory 50656.00k
Timestamp 06/23/2025 09:56:39 AM
Step Count 261 Switch Count 2
Page Faults 0
Page Reclaims 1346
Page Swaps 0
Voluntary Context Switches 30
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
1557
1558
1559 title;
1560 title justify=left 'תמהיל יישויות בכשל';
1561 proc report data=NP_S6;
1562 columns mon NP_Tamhil_ra,CAT;
1563 define mon/group descending;
1564 define CAT/across order=internal ' ';;
48 The SAS System 07:59 Monday, June 23, 2025
1565 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.14 seconds
system cpu time 0.01 seconds
memory 7302.78k
OS Memory 50656.00k
Timestamp 06/23/2025 09:56:39 AM
Step Count 262 Switch Count 2
Page Faults 0
Page Reclaims 1347
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1566
1567
1568 title;
1569 title justify=left 'הפרש מחודש קודם של תמהיל יישויות בכשל';
1570 proc report data=NP_S6;
1571 columns mon NP_Delta_PCT_ra,CAT ;
1572 define mon/group descending;
1573 define CAT/across order=internal ' ';;
1574 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.13 seconds
user cpu time 0.14 seconds
system cpu time 0.01 seconds
memory 7391.50k
OS Memory 50656.00k
Timestamp 06/23/2025 09:56:39 AM
Step Count 263 Switch Count 2
Page Faults 0
Page Reclaims 1347
Page Swaps 0
Voluntary Context Switches 24
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
1575
1576
1577 title;
1578 title j=l 'הפרש מחודש קודם של תמהיל יישויות';
1579 proc report data=NP_S6;
1580 columns mon NP_Delta_Tamhil_nr,CAT;
1581 define mon/group descending;
49 The SAS System 07:59 Monday, June 23, 2025
1582 define CAT/across order=internal ' ';;
1583 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.13 seconds
user cpu time 0.13 seconds
system cpu time 0.00 seconds
memory 7330.28k
OS Memory 50656.00k
Timestamp 06/23/2025 09:56:39 AM
Step Count 264 Switch Count 2
Page Faults 0
Page Reclaims 1343
Page Swaps 0
Voluntary Context Switches 25
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1584
1585
1586 title;
1587 title justify=left 'הפרש מחודש קודם של אחוז יישויות בכשל';
1588 proc report data=NP_S6;
1589 columns mon NP_Delta_Tamhil_ra,CAT;
1590 define mon/group descending;
1591 define CAT/across order=internal ' ';;
1592 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.NP_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.13 seconds
user cpu time 0.14 seconds
system cpu time 0.00 seconds
memory 7327.59k
OS Memory 50656.00k
Timestamp 06/23/2025 09:56:40 AM
Step Count 265 Switch Count 2
Page Faults 0
Page Reclaims 1353
Page Swaps 0
Voluntary Context Switches 25
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1593
1594
1595
1596 /***Pelet S6--pepper***/
1597 /***Pelet S6--pepper***/
1598 /***Pelet S6--pepper***/
1599 /*****Prepare report to print ---change from long to wide strycture****/
50 The SAS System 07:59 Monday, June 23, 2025
1600 %let Ind_P_S6_lastMon=0;
1601 proc sql noprint;
1602 select Ind_prob_Ordinal as Ind_P_S6_lastMon into :Ind_P_S6_lastMon
1603 from P_S6
1604 where mon=&last_mon_in_Report_YYMM2. and mon>=2502
1605 ;
NOTE: No rows were selected.
1606 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 5321.18k
OS Memory 50640.00k
Timestamp 06/23/2025 09:56:40 AM
Step Count 266 Switch Count 0
Page Faults 0
Page Reclaims 68
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1607 %put Ind_P_S6_lastMon=&Ind_P_S6_lastMon.;
Ind_P_S6_lastMon=0
1608
1609 proc sql noprint;
1610 select case when &Ind_P_S6_lastMon.=1 then 'Red'
1611 when max(Ind_prob_Ordinal)=1 then 'Orange'
1612 else 'Green'
1613 end as Ind_Color_Sheet_P_S6 into : Ind_Color_Sheet_P_S6
1614 from P_S6
1615 where mon>=2512 /***עבור פפר צביעת גליון של כשל 12 ח קדימה רק החל מ2512**/
1616 ;
1617 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5345.78k
OS Memory 50640.00k
Timestamp 06/23/2025 09:56:40 AM
Step Count 267 Switch Count 0
Page Faults 0
Page Reclaims 16
Page Swaps 0
Voluntary Context Switches 1
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1618 %put Ind_Color_Sheet_P_S6=&Ind_Color_Sheet_P_S6.;
Ind_Color_Sheet_P_S6=Green
1619
1620
51 The SAS System 07:59 Monday, June 23, 2025
1621 proc format;
1622 value redf 1=red
1623 other=lightgreen;
NOTE: Format REDF is already on the library WORK.FORMATS.
NOTE: Format REDF has been output.
1624 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 95.68k
OS Memory 45516.00k
Timestamp 06/23/2025 09:56:40 AM
Step Count 268 Switch Count 0
Page Faults 0
Page Reclaims 10
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1625
1626
1627 /**Dummy code will not print anyting**/
1628 /***We must put it between 2 none***/
1629 ods select none;
1630 ods excel options( sheet_interval="proc");
1631 proc print data=sashelp.class;run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 345.31k
OS Memory 45516.00k
Timestamp 06/23/2025 09:56:40 AM
Step Count 269 Switch Count 0
Page Faults 0
Page Reclaims 12
Page Swaps 0
Voluntary Context Switches 5
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1632 ods select all;
1633
1634
1635 ods excel options(sheet_name="S6A_P"
1636 embedded_titles='yes'
1637 /*sheet_interval="proc" */
1638 sheet_interval="none" /**Multiple tables in sheet**/
1639 absolute_column_width="13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13
52 The SAS System 07:59 Monday, June 23, 2025
1639 ! ,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13"
1640 tab_color="&Ind_Color_Sheet_P_S6."
1641 );
1642 /**Here multiple reports in same sheet***/
1643 title;
1644 title1 j=l bold color=red height=5 font=simplex 'אוכ-יישויות נקיות שאינן פפר';
1645 title2 j=l bold color=red height=5 font=simplex 'בדיקה1----בדיקת אורדינליות באחוז הכשל בקבוצות ציון כא';
1646 title3 j=l bold color=red height=5 font=simplex 'בדיקת אורדינליות נעשית ללא קטגוריית ערכים ריקים';
1647 title4 j=l bold color=red height=5 font=simplex 'קריטריון להדלקה- לא מתקיימת אורדינליות בין הקטגוריות של קבוצות ציון
1647 ! כא-ככל שעולים בקבוצה אחוז הכשל בקבוצה צריך לגדול';
1648 title5 j=l bold color=red height=5 font=simplex 'הדלקת גליון-החל מ 2502 בגלל שזה פפר';
1649 title6 j=l bold color=black height=4 font=simplex 'הערה:חודשים נחקרים הם חודשים שיש להם נתוני מעקב כשל של 12 חודשים
1649 ! קדימה';
1650 title7 j=l bold color=black height=4 font=simplex 'הערה:חלוקת ציון כא לקבוצות 0-10 10-20 20-30 30-40 40-50 50-60 60-70
1650 ! 70-80 80-90 90-100 וקבוצת ערכים ריקים';
1651 title8 j=l bold color=black height=4 font=simplex 'הערה:KESHEL_FUTURE---add.PANELCS_ZEL_YYMM_Y_CLEAN';
1652 title9 j=l bold color=black height=4 font=simplex 'הערה:ADD.EXTRAS_YYMM_CCHIVE-----prev_mx_pos_prob';
1653 title10 j=l 'עבור פפר בניתוח כשל 12 ח קדימה צביעת גליון באדום רק החל מ2512';
1654 proc report data=P_S6;
1655 columns mon Ind_prob_Ordinal,CAT P_PCT_ra,CAT P_nr,CAT P_nr_Ra,CAT;
1656 define mon/group descending;
1657 define CAT/across order=data ' ';;
1658 compute Ind_prob_Ordinal;
1659 call define(_col_,"Style","style={background=redf.}");
1660 endcompute;
1661 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.56 seconds
user cpu time 0.56 seconds
system cpu time 0.01 seconds
memory 10964.75k
OS Memory 54496.00k
Timestamp 06/23/2025 09:56:40 AM
Step Count 270 Switch Count 0
Page Faults 0
Page Reclaims 2677
Page Swaps 0
Voluntary Context Switches 64
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
1662
1663 title;
1664 title justify=left 'אינד להדלקה';
1665 proc report data=P_S6;
1666 columns mon Ind_prob_Ordinal,CAT;
1667 define mon/group descending;
1668 define CAT/across order=data ' ';
1669 compute Ind_prob_Ordinal;
1670 call define(_col_,"Style","style={background=redf.}");
1671 endcompute;
1672 run;
53 The SAS System 07:59 Monday, June 23, 2025
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.16 seconds
user cpu time 0.16 seconds
system cpu time 0.01 seconds
memory 7789.06k
OS Memory 50912.00k
Timestamp 06/23/2025 09:56:40 AM
Step Count 271 Switch Count 2
Page Faults 0
Page Reclaims 1361
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
1673
1674 title;
1675 title justify=left 'אחוז בכשל בקבוצה';
1676 proc report data=P_S6;
1677 columns mon P_PCT_ra,CAT;
1678 define mon/group descending;
1679 define CAT/across order=data ' ';
1680 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.13 seconds
user cpu time 0.13 seconds
system cpu time 0.00 seconds
memory 7320.31k
OS Memory 50912.00k
Timestamp 06/23/2025 09:56:40 AM
Step Count 272 Switch Count 2
Page Faults 0
Page Reclaims 1349
Page Swaps 0
Voluntary Context Switches 30
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1681
1682 title;
1683 title justify=left 'מספר יישויות בקבוצה';
1684 proc report data=P_S6;
1685 columns mon P_nr,CAT;
1686 define mon/group descending;
1687 define CAT/across order=data ' ';
1688 run;
54 The SAS System 07:59 Monday, June 23, 2025
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.14 seconds
system cpu time 0.00 seconds
memory 7362.43k
OS Memory 50912.00k
Timestamp 06/23/2025 09:56:41 AM
Step Count 273 Switch Count 2
Page Faults 0
Page Reclaims 1341
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1689
1690
1691 title;
1692 title justify=left 'מספר יישויות בכשל בקבוצה';
1693 proc report data=P_S6;
1694 columns mon P_nr_Ra,CAT;
1695 define mon/group descending;
1696 define CAT/across order=data ' ';
1697 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.16 seconds
user cpu time 0.16 seconds
system cpu time 0.01 seconds
memory 7331.81k
OS Memory 50912.00k
Timestamp 06/23/2025 09:56:41 AM
Step Count 274 Switch Count 2
Page Faults 0
Page Reclaims 1341
Page Swaps 0
Voluntary Context Switches 26
Involuntary Context Switches 2
Block Input Operations 0
Block Output Operations 0
1698
1699
1700
1701 proc sql noprint;
1702 select case when max(P_IND_Prob)=1 then 'Red' else 'Green' end as Ind_Color_Sheet_P_S6b into : Ind_Color_Sheet_P_S6b
1703 from P_S6
1704 where mon>=2502
1705 ;
1706 quit;
NOTE: PROCEDURE SQL used (Total process time):
55 The SAS System 07:59 Monday, June 23, 2025
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5322.53k
OS Memory 50896.00k
Timestamp 06/23/2025 09:56:41 AM
Step Count 275 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 1
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1707 %put Ind_Color_Sheet_P_S6b=&Ind_Color_Sheet_P_S6b.;
Ind_Color_Sheet_P_S6b=Green
1708
1709
1710 /**Dummy code will not print anyting**/
1711 /***We must put it between 2 none***/
1712 ods select none;
1713 ods excel options( sheet_interval="proc");
1714 proc print data=sashelp.class;run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 349.03k
OS Memory 45772.00k
Timestamp 06/23/2025 09:56:41 AM
Step Count 276 Switch Count 0
Page Faults 0
Page Reclaims 7
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1715 ods select all;
1716
1717
1718
1719 ods excel options(sheet_name="S6b_P"
1720 embedded_titles='yes'
1721 /*sheet_interval="proc" */
1722 sheet_interval="none" /**Multiple tables in sheet**/
1723 absolute_column_width="13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13
1723 ! ,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13"
1724 tab_color="&Ind_Color_Sheet_P_S6b."
1725 );
1726
1727 title;
56 The SAS System 07:59 Monday, June 23, 2025
1728 title1 j=l bold color=red height=5 font=simplex 'אוכ-יישויות נקיות פפר';
1729 title2 j=l bold color=red height=5 font=simplex 'בדיקה2-בדיקת יציבות במספר יישויות נקיות, מספר יישויות בכשל';
1730 title3 j=l bold color=red height=5 font=simplex 'הערה: קירטריון להדלקה שינוי של מעל 3% בתמהיל יישויות/תמהיל יישויות
1730 ! בכשל/אחוז כשל מחודש לחודש';
1731 title4 j=l 'IF abs(P_Delta_Tamhil_nr)>0.03 OR abs(P_Delta_PCT_ra)>0.03 OR abs(P_Delta_PCT_ra)>0.03 then P_IND_Prob=1';
1732 title5 j=l 'הערה- בודקים שינויים בתמהיל בין חודש לחודש קודם';
1733 title6 j=l 'הערה:חדשים נחקרים הם חודשים שיש להם נתוני מעקב כשל של 12 חודשים קדימה';
1734 title7 j=l 'עבור פפר בניתוח כשל 12 ח קדימה צביעת גליון באדום רק החל מ2512';
1735 proc report data=P_S6;
1736 columns mon P_IND_Prob,CAT P_nr,CAT P_nr_Ra,CAT P_PCT_ra,CAT P_Tamhil_nr,CAT P_Tamhil_ra,CAT
1736 ! P_Delta_PCT_ra,CAT P_Delta_Tamhil_nr,CAT P_Delta_Tamhil_ra,CAT;
1737 define mon/group descending;
1738 define CAT/across order=data ' ';;
1739 compute P_IND_Prob;
1740 call define(_col_,"Style","style={background=redf.}");
1741 endcompute;
1742 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 1.12 seconds
user cpu time 1.09 seconds
system cpu time 0.03 seconds
memory 18178.92k
OS Memory 62944.00k
Timestamp 06/23/2025 09:56:42 AM
Step Count 277 Switch Count 0
Page Faults 0
Page Reclaims 9873
Page Swaps 0
Voluntary Context Switches 73
Involuntary Context Switches 3
Block Input Operations 0
Block Output Operations 0
1743
1744 title;
1745 title justify=left 'אינד להדלקה';
1746 proc report data=P_S6;
1747 columns mon P_IND_Prob,CAT;
1748 define mon/group descending;
1749 define CAT/across order=data ' ';;
1750 compute P_IND_Prob;
1751 call define(_col_,"Style","style={background=redf.}");
1752 endcompute;
1753 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.19 seconds
user cpu time 0.19 seconds
system cpu time 0.02 seconds
memory 7675.12k
OS Memory 52448.00k
57 The SAS System 07:59 Monday, June 23, 2025
Timestamp 06/23/2025 09:56:42 AM
Step Count 278 Switch Count 2
Page Faults 0
Page Reclaims 2750
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1754
1755 title;
1756 title justify=left 'מספר יישויות';
1757 proc report data=P_S6;
1758 columns mon P_nr,CAT;
1759 define mon/group descending;
1760 define CAT/across order=data ' ';;
1761 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.13 seconds
system cpu time 0.01 seconds
memory 7340.78k
OS Memory 52448.00k
Timestamp 06/23/2025 09:56:42 AM
Step Count 279 Switch Count 2
Page Faults 0
Page Reclaims 1364
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 9
Block Input Operations 0
Block Output Operations 0
1762
1763 title;
1764 title justify=left 'מספר יישויות בכשל';
1765 proc report data=P_S6;
1766 columns mon P_nr_Ra,CAT;
1767 define mon/group descending;
1768 define CAT/across order=data ' ';;
1769 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.14 seconds
system cpu time 0.01 seconds
memory 7290.15k
OS Memory 52448.00k
Timestamp 06/23/2025 09:56:42 AM
Step Count 280 Switch Count 2
58 The SAS System 07:59 Monday, June 23, 2025
Page Faults 0
Page Reclaims 1350
Page Swaps 0
Voluntary Context Switches 23
Involuntary Context Switches 20
Block Input Operations 0
Block Output Operations 0
1770
1771
1772 title;
1773 title justify=left 'אחוז יישויות בכשל';
1774 proc report data=P_S6;
1775 columns mon P_PCT_ra,CAT;
1776 define mon/group descending;
1777 define CAT/across order=data ' ';;
1778 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.16 seconds
user cpu time 0.16 seconds
system cpu time 0.00 seconds
memory 7315.87k
OS Memory 52448.00k
Timestamp 06/23/2025 09:56:43 AM
Step Count 281 Switch Count 2
Page Faults 0
Page Reclaims 1353
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1779
1780 title;
1781 title justify=left 'תמהיל יישויות';
1782 proc report data=P_S6;
1783 columns mon P_Tamhil_nr,CAT;
1784 define mon/group descending;
1785 define CAT/across order=data ' ';;
1786 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.14 seconds
system cpu time 0.01 seconds
memory 7366.81k
OS Memory 52448.00k
Timestamp 06/23/2025 09:56:43 AM
59 The SAS System 07:59 Monday, June 23, 2025
Step Count 282 Switch Count 2
Page Faults 0
Page Reclaims 1357
Page Swaps 0
Voluntary Context Switches 20
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1787
1788
1789 title;
1790 title justify=left 'תמהיל יישויות בכשל';
1791 proc report data=P_S6;
1792 columns mon P_Tamhil_ra,CAT ;
1793 define mon/group descending;
1794 define CAT/across order=data ' ';;
1795 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.15 seconds
user cpu time 0.15 seconds
system cpu time 0.01 seconds
memory 7314.62k
OS Memory 52448.00k
Timestamp 06/23/2025 09:56:43 AM
Step Count 283 Switch Count 2
Page Faults 0
Page Reclaims 1345
Page Swaps 0
Voluntary Context Switches 26
Involuntary Context Switches 2
Block Input Operations 0
Block Output Operations 0
1796
1797
1798 title;
1799 title justify=left 'הפרש מחודש קודם של אחוז יישויות בכשל';
1800 proc report data=P_S6;
1801 columns mon P_Delta_PCT_ra,CAT;
1802 define mon/group descending;
1803 define CAT/across order=data ' ';;
1804 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.15 seconds
user cpu time 0.15 seconds
system cpu time 0.00 seconds
memory 7290.40k
OS Memory 52448.00k
60 The SAS System 07:59 Monday, June 23, 2025
Timestamp 06/23/2025 09:56:43 AM
Step Count 284 Switch Count 2
Page Faults 0
Page Reclaims 1343
Page Swaps 0
Voluntary Context Switches 25
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1805
1806 title;
1807 title justify=left 'הפרש מחודש קודם של תמהיל יישויות';
1808 proc report data=P_S6;
1809 columns mon P_Delta_Tamhil_nr,CAT;
1810 define mon/group descending;
1811 define CAT/across order=data ' ';;
1812 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.15 seconds
user cpu time 0.15 seconds
system cpu time 0.01 seconds
memory 7315.84k
OS Memory 52448.00k
Timestamp 06/23/2025 09:56:43 AM
Step Count 285 Switch Count 2
Page Faults 0
Page Reclaims 1341
Page Swaps 0
Voluntary Context Switches 25
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1813
1814 title;
1815 title justify=left 'הפרש מחודש קודם של תמהיל ישויות בכשל';
1816 proc report data=P_S6;
1817 columns mon P_Delta_Tamhil_ra,CAT;
1818 define mon/group descending;
1819 define CAT/across order=data ' ';;
1820 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 264 observations read from the data set WORK.P_S6.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.14 seconds
user cpu time 0.15 seconds
system cpu time 0.00 seconds
memory 7366.21k
OS Memory 52448.00k
Timestamp 06/23/2025 09:56:43 AM
Step Count 286 Switch Count 2
61 The SAS System 07:59 Monday, June 23, 2025
Page Faults 0
Page Reclaims 1342
Page Swaps 0
Voluntary Context Switches 24
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
1821
1822
1823
1824 /****Pelet S7---No pepper***/
1825 /****Pelet S7---No pepper***/
1826 /****Pelet S7---No pepper***/
1827 proc sql noprint;
1828 select NP_IND_Prob as Ind_NP_S7_lastMon into :Ind_NP_S7_lastMon
1829 from NP_Want_Mavarim_S7
1830 where mon=&last_mon_in_Report_YYMM1.
1831 ;
1832 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5836.87k
OS Memory 52948.00k
Timestamp 06/23/2025 09:56:43 AM
Step Count 287 Switch Count 0
Page Faults 0
Page Reclaims 183
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1833 %put Ind_NP_S7_lastMon=&Ind_NP_S7_lastMon.;
Ind_NP_S7_lastMon= 0
1834
1835 proc sql noprint;
1836 select case when &Ind_NP_S7_lastMon.=1 then 'Red'
1837 when max(NP_IND_Prob)=1 then 'Orange'
1838 else 'Green'
1839 end as Ind_Color_Sheet_NP_S7 into : Ind_Color_Sheet_NP_S7
1840 from NP_Want_Mavarim_S7
1841 ;
1842 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5836.93k
OS Memory 52948.00k
Timestamp 06/23/2025 09:56:43 AM
Step Count 288 Switch Count 23
Page Faults 0
62 The SAS System 07:59 Monday, June 23, 2025
Page Reclaims 127
Page Swaps 0
Voluntary Context Switches 58
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1843 %put Ind_Color_Sheet_NP_S7=&Ind_Color_Sheet_NP_S7.;
Ind_Color_Sheet_NP_S7=Orange
1844
1845
1846
1847 proc format;
1848 value red_fmt
1849 1=red
1850 other=lightgreen;
NOTE: Format RED_FMT is already on the library WORK.FORMATS.
NOTE: Format RED_FMT has been output.
1851 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 98.62k
OS Memory 47308.00k
Timestamp 06/23/2025 09:56:43 AM
Step Count 289 Switch Count 0
Page Faults 0
Page Reclaims 10
Page Swaps 0
Voluntary Context Switches 2
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1852
1853
1854 ods excel options (sheet_name='S7_NP'
1855 sheet_interval="proc"
1856 absolute_column_width="13,13,13,25,25,25,8,8"
1857 row_heights='30,16,20,20,20'
1858 gridlines = 'yes'
1859 tab_color="&Ind_Color_Sheet_NP_S7."
1860 );
1861 title;
1862 title1 j=l bold color=red height=5 font=simplex 'אוכ-יישויות 833 לא מקושרים שאינן פפר';
1863 title2 j=l bold color=red height=5 font=simplex 'בקרת מעברים בקבוצות ציון כא מחודש לחודש הבא';
1864 title3 j=l bold color=red height=5 font=simplex 'בחישוב התמהיל לא לוקחים בחשבון מעבר מקטגוריה ריק לריק';
1865 title4 j=l bold color=red height=5 font=simplex 'קריטריון להדלקה- שינוי בתמהיל במעל 1.5%';
1866 title5 j=l bold color=black height=5 font=simplex 'שיטת עבודה-בכל חודש בודקים את קבוצת ציון כא באותו חודש וחודש קודם';
1867 title6 j=l bold color=black height=5 font=simplex'מחשבים תמהיל יישויות לכל שילוב של קבוצת ציון כא חודש נוכחי וחודש קודם
1867 ! והפרש בתמהיל מחודש קודם';
1868 /*title7 j=l bold color=black height=5 font=simplex 'מחשבים הפרש בתמהיל של מעברים מחודש t-1 ל t לבין מעברים מחודש
1868 ! t-2 ל t-1';*/
1869 proc report data=NP_Want_Mavarim_S7 missing;
63 The SAS System 07:59 Monday, June 23, 2025
1870 columns _CAT_ CAT _PREVCAT_ PREVCAT Ind_Same_Better_Worse dif_Categories NP_IND_Prob,mon NP_nr,mon
1870 ! NP_tamhil_nr,mon NP_Dif_Tamhil_nr,mon;
1871 define _CAT_/group;
1872 define CAT/group;
1873 define _PREVCAT_/group;
1874 define PREVCAT/group;
1875 define Ind_Same_Better_Worse/group;
1876 define dif_Categories/group;
1877 define mon/across order=data ' ';
1878 define NP_IND_Prob/mean;
1879 compute NP_IND_Prob;
1880 call define(_col_,"Style","style={background=red_fmt.}");
1881 endcomp;
1882 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 5018 observations read from the data set WORK.NP_WANT_MAVARIM_S7.
NOTE: PROCEDURE REPORT used (Total process time):
real time 9.86 seconds
user cpu time 9.65 seconds
system cpu time 0.23 seconds
memory 112540.71k
OS Memory 171300.00k
Timestamp 06/23/2025 09:56:53 AM
Step Count 290 Switch Count 0
Page Faults 0
Page Reclaims 102120
Page Swaps 0
Voluntary Context Switches 128
Involuntary Context Switches 20
Block Input Operations 0
Block Output Operations 0
1883
1884
1885 /*****S7---No pepper---matrics****/
1886 /*****S7---No pepper---matrics****/
1887 /*****S7---No pepper---matrics****/
1888 data last_mon_Mavarim;
1889 set NP_Want_Mavarim_S7(Where=(mon=&last_mon_in_Report_YYMM1.));
1890 Run;
NOTE: There were 131 observations read from the data set WORK.NP_WANT_MAVARIM_S7.
WHERE mon=2505;
NOTE: The data set WORK.LAST_MON_MAVARIM has 131 observations and 12 variables.
NOTE: Compressing data set WORK.LAST_MON_MAVARIM increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 1096.18k
OS Memory 55776.00k
Timestamp 06/23/2025 09:56:53 AM
Step Count 291 Switch Count 3
Page Faults 0
Page Reclaims 396
64 The SAS System 07:59 Monday, June 23, 2025
Page Swaps 0
Voluntary Context Switches 20
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1891
1892
1893 proc sort data=last_mon_Mavarim;by descending mon;Run;
NOTE: There were 131 observations read from the data set WORK.LAST_MON_MAVARIM.
NOTE: SAS sort was used.
NOTE: The data set WORK.LAST_MON_MAVARIM has 131 observations and 12 variables.
NOTE: Compressing data set WORK.LAST_MON_MAVARIM increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 478.78k
OS Memory 55260.00k
Timestamp 06/23/2025 09:56:53 AM
Step Count 292 Switch Count 2
Page Faults 0
Page Reclaims 65
Page Swaps 0
Voluntary Context Switches 23
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1894
1895 /**Dummy code will not print anyting**/
1896 /***We must put it between 2 none***/
1897 ods select none;
1898 ods excel options( sheet_interval="proc");
1899 proc print data=sashelp.class;run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 348.78k
OS Memory 55260.00k
Timestamp 06/23/2025 09:56:53 AM
Step Count 293 Switch Count 0
Page Faults 0
Page Reclaims 106
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
65 The SAS System 07:59 Monday, June 23, 2025
1900 ods select all;
1901
1902
1903 ods excel options (sheet_name='S7_NP_Matrix'
1904 sheet_interval="none" /**Multiple tables in one sheet**/
1905 tab_color="&Ind_Color_Sheet_NP_S7."
1906 );
1907
1908 title;
1909 title1 'מטריצה - לא פפר- עבור חודש אחרון בבלד';
1910 title2 'הקבוצות אינן דירוגים אלה קבוצות ציון כא';
1911 title3 '
1912 0_NO_EXIST,
1913 1_NULL ,
1914 2_0TO10 ,
1915 3_10TO20 ,
1916 4_20TO30 ,
1917 5_30TO40 ,
1918 6_40TO50 ,
1919 7_50TO60 ,
1920 8_60TO70 ,
1921 9_70TO80 ,
1922 10_80TO90 ,
1923 11_90TO100';
1924 proc tabulate data=last_mon_Mavarim missing;
1925 by descending mon ;
1926 class _PREVCAT_ _CAT_ ;
1927 var NP_IND_Prob;
1928 table _PREVCAT_='' all, (_CAT_='נוכחי' all)*(SUM=''*NP_IND_Prob='אינד להדלקה'*f=8.0) / rts=10 misstext='0' box='קודם';
1929 run;
NOTE: There were 131 observations read from the data set WORK.LAST_MON_MAVARIM.
NOTE: PROCEDURE TABULATE used (Total process time):
real time 0.23 seconds
user cpu time 0.18 seconds
system cpu time 0.01 seconds
memory 2698.17k
OS Memory 56544.00k
Timestamp 06/23/2025 09:56:54 AM
Step Count 294 Switch Count 8
Page Faults 0
Page Reclaims 2799
Page Swaps 0
Voluntary Context Switches 102
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1930 title;
1931 proc tabulate data=last_mon_Mavarim missing;
1932 by descending mon ;
1933 class _PREVCAT_ _CAT_ ;
1934 var NP_nr;
1935 table _PREVCAT_='' all, (_CAT_='נוכחי' all)*(SUM=''*NP_nr='מספר_יישויות'*f=comma32.) / rts=10 misstext='0' box='קודם';
1936 run;
NOTE: There were 131 observations read from the data set WORK.LAST_MON_MAVARIM.
66 The SAS System 07:59 Monday, June 23, 2025
NOTE: PROCEDURE TABULATE used (Total process time):
real time 0.10 seconds
user cpu time 0.09 seconds
system cpu time 0.00 seconds
memory 2821.31k
OS Memory 56544.00k
Timestamp 06/23/2025 09:56:54 AM
Step Count 295 Switch Count 10
Page Faults 0
Page Reclaims 177
Page Swaps 0
Voluntary Context Switches 83
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1937 proc tabulate data=last_mon_Mavarim missing;
1938 by descending mon ;
1939 class _PREVCAT_ _CAT_ ;
1940 var NP_tamhil_nr;
1941 table _PREVCAT_='' all, (_CAT_='נוכחי' all)*(SUM=''*NP_tamhil_nr='תמהיל'*f=percent8.2) / rts=10 misstext='0' box='קודם';
1942 run;
NOTE: There were 131 observations read from the data set WORK.LAST_MON_MAVARIM.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE TABULATE used (Total process time):
real time 0.11 seconds
user cpu time 0.09 seconds
system cpu time 0.01 seconds
memory 2768.68k
OS Memory 56544.00k
Timestamp 06/23/2025 09:56:54 AM
Step Count 296 Switch Count 10
Page Faults 0
Page Reclaims 179
Page Swaps 0
Voluntary Context Switches 86
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1943 proc tabulate data=last_mon_Mavarim missing;
1944 by descending mon ;
1945 class _PREVCAT_ _CAT_ ;
1946 var NP_Dif_Tamhil_nr;
1947 table _PREVCAT_='' all, (_CAT_='נוכחי' all)*(SUM=''*NP_Dif_Tamhil_nr='הפרש_תמהיל'*f=percent8.2) / rts=10 misstext='0'
1947 ! box='קודם';
1948 run;
NOTE: There were 131 observations read from the data set WORK.LAST_MON_MAVARIM.
NOTE: PROCEDURE TABULATE used (Total process time):
real time 0.10 seconds
user cpu time 0.10 seconds
system cpu time 0.00 seconds
memory 2763.28k
OS Memory 56544.00k
67 The SAS System 07:59 Monday, June 23, 2025
Timestamp 06/23/2025 09:56:54 AM
Step Count 297 Switch Count 9
Page Faults 0
Page Reclaims 148
Page Swaps 0
Voluntary Context Switches 80
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1949
1950
1951
1952 /***S7----Pepper***/
1953 /***S7----Pepper***/
1954 /***S7----Pepper***/
1955 proc sql noprint;
1956 select max(P_IND_Prob) as Ind_P_S7_lastMon into :Ind_P_S7_lastMon
1957 from P_Want_Mavarim_S7
1958 where mon=&last_mon_in_Report_YYMM1. and mon>=2502
1959 ;
1960 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5701.87k
OS Memory 60060.00k
Timestamp 06/23/2025 09:56:54 AM
Step Count 298 Switch Count 1
Page Faults 0
Page Reclaims 113
Page Swaps 0
Voluntary Context Switches 6
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1961 %put Ind_P_S7_lastMon=&Ind_P_S7_lastMon.;
Ind_P_S7_lastMon= 1
1962
1963
1964 proc sql noprint;
1965 select case when &Ind_P_S7_lastMon.=1 then 'Red'
1966 when max(P_IND_Prob)=1 then 'Orange'
1967 else 'Green'
1968 end as Ind_Color_Sheet_P_S7 into : Ind_Color_Sheet_P_S7
1969 from P_Want_Mavarim_S7
1970 where mon>=2502
1971 ;
1972 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5725.18k
68 The SAS System 07:59 Monday, June 23, 2025
OS Memory 60060.00k
Timestamp 06/23/2025 09:56:54 AM
Step Count 299 Switch Count 0
Page Faults 0
Page Reclaims 106
Page Swaps 0
Voluntary Context Switches 25
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1973 %put Ind_Color_Sheet_P_S7=&Ind_Color_Sheet_P_S7.;
Ind_Color_Sheet_P_S7=Red
1974
1975
1976
1977 proc format;
1978 value red_fmt
1979 1=red
1980 other=lightgreen;
NOTE: Format RED_FMT is already on the library WORK.FORMATS.
NOTE: Format RED_FMT has been output.
1981 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 97.25k
OS Memory 54484.00k
Timestamp 06/23/2025 09:56:54 AM
Step Count 300 Switch Count 0
Page Faults 0
Page Reclaims 16
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
1982
1983
1984
1985 ods excel options (sheet_name='S7_P'
1986 sheet_interval="proc"
1987 absolute_column_width="13,13,13,25,25,25,8,8"
1988 row_heights='30,16,20,20,20'
1989 gridlines = 'yes'
1990 tab_color="&Ind_Color_Sheet_P_S7."
1991 );
1992 title;
1993 title1 j=l bold color=red height=5 font=simplex 'אוכ-יישויות לא מקושרים פפר';
1994 title2 j=l bold color=red height=5 font=simplex 'בקרת מעברים בקבוצות ציון כא מחודש לחודש הבא';
1995 title3 j=l bold color=red height=6 font=simplex 'הקבוצות אינן דירוגים אלה קבוצות ציון כא';
1996 title4 j=l bold color=red height=5 font=simplex 'בחישוב התמהיל לא לוקחים בחשבון מעבר מקטגוריה ריק לריק';
1997 title5 j=l bold color=red height=5 font=simplex 'קריטריון להדלקה- שינוי בתמהיל במעל 1.5%';
69 The SAS System 07:59 Monday, June 23, 2025
1998 title6 j=l bold color=black height=5 font=simplex 'שיטת עבודה-בכל חודש בודקים את קבוצת ציון כא באותו חודש וחודש קודם';
1999 title7 j=l bold color=black height=5 font=simplex'מחשבים תמהיל יישויות לכל שילוב של קבוצת ציון כא חודש נוכחי וחודש קודם
1999 ! והפרש בתמהיל מחודש קודם';
2000 /*title8 j=l bold color=black height=5 font=simplex 'מחשבים הפרש בתמהיל של מעברים מחודש t-1 ל t לבין מעברים מחודש
2000 ! t-2 ל t-1';*/
2001 proc report data=P_Want_Mavarim_S7 missing;
2002 columns _CAT_ CAT _PREVCAT_ PREVCAT Ind_Same_Better_Worse dif_Categories P_IND_Prob,mon P_nr,mon
2002 ! P_tamhil_nr,mon P_Dif_Tamhil_nr,mon;
2003 define _CAT_/group;
2004 define CAT/group;
2005 define _PREVCAT_/group;
2006 define PREVCAT/group;
2007 define Ind_Same_Better_Worse/group;
2008 define dif_Categories/group;
2009 define mon/across order=data ' ';
2010 define P_IND_Prob/mean;
2011 compute P_IND_Prob;
2012 call define(_col_,"Style","style={background=red_fmt.}");
2013 endcomp;
2014 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 3702 observations read from the data set WORK.P_WANT_MAVARIM_S7.
NOTE: PROCEDURE REPORT used (Total process time):
real time 9.08 seconds
user cpu time 8.85 seconds
system cpu time 0.19 seconds
memory 101968.54k
OS Memory 165332.00k
Timestamp 06/23/2025 09:57:03 AM
Step Count 301 Switch Count 0
Page Faults 0
Page Reclaims 95045
Page Swaps 0
Voluntary Context Switches 116
Involuntary Context Switches 24
Block Input Operations 0
Block Output Operations 0
2015
2016
2017
2018 /****Pelet S8--No pepper****/
2019 /****Pelet S8--No pepper****/
2020 /****Pelet S8--No pepper****/
2021 proc sql noprint;
2022 select max(NP_IND_Prob) as Ind_NP_S8_lastMon into :Ind_NP_S8_lastMon
2023 from NP_S8_Want1
2024 where mon=&last_mon_in_Report_YYMM2.
2025 ;
2026 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5768.25k
OS Memory 65500.00k
70 The SAS System 07:59 Monday, June 23, 2025
Timestamp 06/23/2025 09:57:03 AM
Step Count 302 Switch Count 1
Page Faults 0
Page Reclaims 327
Page Swaps 0
Voluntary Context Switches 7
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
2027 %put Ind_NP_S8_lastMon=&Ind_NP_S8_lastMon.;
Ind_NP_S8_lastMon= 0
2028
2029
2030 proc sql noprint;
2031 select case when &Ind_NP_S8_lastMon.=1 then 'Red'
2032 when max(NP_IND_Prob)=1 then 'Orange'
2033 else 'Green'
2034 end as Ind_Color_Sheet_NP_S8 into : Ind_Color_Sheet_NP_S8
2035 from NP_S8_Want1
2036 ;
2037 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 5766.96k
OS Memory 65500.00k
Timestamp 06/23/2025 09:57:03 AM
Step Count 303 Switch Count 1
Page Faults 0
Page Reclaims 126
Page Swaps 0
Voluntary Context Switches 2
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
2038 %put Ind_Color_Sheet_NP_S8=&Ind_Color_Sheet_NP_S8.;
Ind_Color_Sheet_NP_S8=Green
2039
2040
2041
2042 proc format;
2043 value red_fmt
2044 1=red
2045 other=lightgreen;
NOTE: Format RED_FMT is already on the library WORK.FORMATS.
NOTE: Format RED_FMT has been output.
2046 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 97.50k
71 The SAS System 07:59 Monday, June 23, 2025
OS Memory 59860.00k
Timestamp 06/23/2025 09:57:03 AM
Step Count 304 Switch Count 0
Page Faults 0
Page Reclaims 28
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
2047
2048
2049
2050
2051 ods excel options (sheet_name='S8-NP'
2052 sheet_interval="proc"
2053 absolute_column_width="13,13,13,25,25,25,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10
2053 ! ,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10"
2054 row_heights='30,16,20,20,20'
2055 gridlines = 'yes'
2056 tab_color="&Ind_Color_Sheet_NP_S8."
2057 );
2058
2059 title;
2060 title1 j=l bold color=red height=5 font=simplex 'אוכ-יישויות נקיות מחטיבה 833 לא מקושרים שאינן פפר';
2061 title2 j=l bold color=red height=5 font=simplex 'בקרת מעברים בקבוצות ציון כא מחודש לחודש הבא ובחינת כשל 12 ח קדימה';
2062 title3 j=l bold color=red height=6 font=simplex 'הקבוצות אינן דירוגים אלה קבוצות ציון כא';
2063 title4 j=l bold color=red height=5 font=simplex 'קריטריון להדלקה- שינוי בתמהיל במעל 3%';
2064 title5 j=l 'שיטת עבודה-בכל חודש לוקחים יישויות נקיות 833 לא מקושרים שאינן פפר ובודקים את קבוצת ציון כא באותו חודש וחודש
2064 ! קודם';
2065 title6 j=l 'מחשבים תמהיל יישויות לכל שילוב של קבוצת ציון כא חודש נוכחי וחודש קודם והפרש בתמהיל מחודש קודם';
2066 title7 j=l 'מחשבים הפרש בתמהיל של מעברים מחודש t-1 ל t לבין מעברים מחודש t-2 ל t-1';
2067 title8 j=l 'בחישוב התמהיל לא לוקחים בחשבון מעבר מקטגוריה ריק לריק';
2068 title9 j=l 'פלט של טבלה אחת -פחות נוח לעבודה';
2069 proc report data=NP_S8_Want1 missing;
2070 columns
2071 _CAT_
2072 CAT
2073 _PREVCAT_
2074 PREVCAT
2075 Ind_Same_Better_Worse
2076 dif_Categories
2077 NP_IND_Prob,mon
2078 NP_nr,mon
2079 NP_nr_RA,mon
2080 NP_PCT_ra,mon
2081 NP_tamhil_nr,mon
2082 NP_tamhil_nr_ra,mon
2083 NP_Dif_PCT_ra,mon
2084 NP_Dif_Tamhil_nr,mon
2085 NP_Dif_Tamhil_nr_ra,mon
2086 ;
2087 define _CAT_/group;
2088 define CAT/group;
2089 define _PREVCAT_/group;
2090 define PREVCAT/group;
72 The SAS System 07:59 Monday, June 23, 2025
2091 define Ind_Same_Better_Worse/group;
2092 define dif_Categories/group;
2093 define mon/across order=data ' ';
2094 define NP_IND_Prob/mean;
2095 compute NP_IND_Prob;
2096 call define(_col_,"Style","style={background=red_fmt.}");
2097 endcomp;
2098 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 3001 observations read from the data set WORK.NP_S8_WANT1.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 13.38 seconds
user cpu time 13.14 seconds
system cpu time 0.24 seconds
memory 142905.07k
OS Memory 216364.00k
Timestamp 06/23/2025 09:57:16 AM
Step Count 305 Switch Count 0
Page Faults 0
Page Reclaims 127508
Page Swaps 0
Voluntary Context Switches 130
Involuntary Context Switches 36
Block Input Operations 0
Block Output Operations 0
2099
2100
2101
2102 /***Pelet S8---pepper***/
2103 /***Pelet S8---pepper***/
2104 /***Pelet S8---pepper***/
2105 proc sql noprint;
2106 select max(P_IND_Prob) as Ind_P_S8_lastMon into :Ind_P_S8_lastMon
2107 from P_S8_Want1
2108 where mon=&last_mon_in_Report_YYMM2.
2109 ;
2110 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 5640.28k
OS Memory 73308.00k
Timestamp 06/23/2025 09:57:16 AM
Step Count 306 Switch Count 0
Page Faults 0
Page Reclaims 299
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
73 The SAS System 07:59 Monday, June 23, 2025
2111 %put Ind_P_S8_lastMon=&Ind_P_S8_lastMon.;
Ind_P_S8_lastMon= 0
2112
2113
2114 proc sql noprint;
2115 select case when &Ind_P_S8_lastMon.=1 then 'Red'
2116 when max(P_IND_Prob)=1 then 'Orange'
2117 else 'Green'
2118 end as Ind_Color_Sheet_P_S8 into : Ind_Color_Sheet_P_S8
2119 from P_S8_Want1
2120 where mon>=2512 /***עבור פפר בניתוח כשל 12 ח קדימה צביעת גליון באדום רק החלמ2512***/
2121 ;
2122 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 5663.25k
OS Memory 73308.00k
Timestamp 06/23/2025 09:57:16 AM
Step Count 307 Switch Count 0
Page Faults 0
Page Reclaims 94
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
2123 %put Ind_Color_Sheet_P_S8=&Ind_Color_Sheet_P_S8.;
Ind_Color_Sheet_P_S8=Green
2124
2125
2126 proc format;
2127 value red_fmt
2128 1=red
2129 other=lightgreen;
NOTE: Format RED_FMT is already on the library WORK.FORMATS.
NOTE: Format RED_FMT has been output.
2130 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 97.09k
OS Memory 67796.00k
Timestamp 06/23/2025 09:57:16 AM
Step Count 308 Switch Count 0
Page Faults 0
Page Reclaims 28
Page Swaps 0
Voluntary Context Switches 4
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
74 The SAS System 07:59 Monday, June 23, 2025
2131
2132
2133 ods excel options (sheet_name='S8-P'
2134 sheet_interval="proc"
2135 absolute_column_width="13,13,13,25,25,25"
2136 row_heights='30,16,20,20,20'
2137 gridlines = 'yes'
2138 tab_color="&Ind_Color_Sheet_P_S8."
2139 );
2140 title;
2141 title1 j=l 'אוכ-יישויות נקיות פפר לא מקושרים';
2142 title2 j=l bold color=red height=5 font=simplex 'בקרת מעברים בקבוצות ציון כא מחודש לחודש הבא ובחינת כשל 12 ח קדימה';
2143 title3 j=l bold color=red height=6 font=simplex 'הקבוצות אינן דירוגים אלה קבוצות ציון כא';
2144 title4 j=l 'שיטת עבודה-בכל חודש לוקחים יישויות נקיות 833 לא מקושרים פפר ובודקים את קבוצת ציון כא באותו חודש וחודש
2144 ! קודם';
2145 title5 j=l 'מחשבים תמהיל יישויות לכל שילוב של קבוצת ציון כא חודש נוכחי וחודש קודם והפרש בתמהיל מחודש קודם';
2146 title6 j=l 'מחשבים הפרש בתמהיל של מעברים מחודש t-1 ל t לבין מעברים מחודש t-2 ל t-1';
2147 title7 j=l 'בחישוב התמהיל לא לוקחים בחשבון מעבר מקטגוריה ריק לריק';
2148 title8 j=l 'קריטריון להדלקה- שינוי בתמהיל במעל 3%';
2149 title9 j=l 'עבור פפר בניתוח כשל 12 ח קדימה צביעת גליון באדום רק החל מ2512';
2150 proc report data=P_S8_Want1 missing;
2151 columns
2152 _CAT_
2153 CAT
2154 _PREVCAT_
2155 PREVCAT
2156 Ind_Same_Better_Worse
2157 dif_Categories
2158 P_IND_Prob,mon
2159 P_nr,mon
2160 NP_nr_RA,mon
2161 P_PCT_ra,mon
2162 P_tamhil_nr,mon
2163 P_tamhil_nr_ra,mon
2164 P_Dif_PCT_ra,mon
2165 P_Dif_Tamhil_nr,mon
2166 P_Dif_Tamhil_nr_ra,mon
2167 ;
2168 define _CAT_/group;
2169 define CAT/group;
2170 define _PREVCAT_/group;
2171 define PREVCAT/group;
2172 define Ind_Same_Better_Worse/group;
2173 define dif_Categories/group;
2174 define mon/across order=data ' ';
2175 define P_IND_Prob/mean;
2176 compute P_IND_Prob;
2177 call define(_col_,"Style","style={background=red_fmt.}");
2178 endcomp;
2179 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 2135 observations read from the data set WORK.P_S8_WANT1.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE REPORT used (Total process time):
real time 11.05 seconds
user cpu time 10.84 seconds
75 The SAS System 07:59 Monday, June 23, 2025
system cpu time 0.17 seconds
memory 119868.67k
OS Memory 198292.00k
Timestamp 06/23/2025 09:57:27 AM
Step Count 309 Switch Count 0
Page Faults 0
Page Reclaims 105764
Page Swaps 0
Voluntary Context Switches 145
Involuntary Context Switches 20
Block Input Operations 0
Block Output Operations 0
2180
2181
2182 /***PELET S9-Gini***/
2183 /***PELET S9-Gini***/
2184 /***PELET S9-Gini***/
2185 ods excel options (sheet_name='S9_Gini'
2186 sheet_interval="proc"
2187 gridlines = 'yes'
2188 tab_color='white'
2189 );
2190 title;
2191 title1 j=l color=red height=3 'אוכ-יישויות נקיות בעלות ציון כא חיובי';
2192 title2 j=l color=red height=3 'מדד גני -בודק ציון כא מול כשל בפועל';
2193 title3 j=l 'לא הוגדר קריטירון להדלקה';
2194 /*proc print data=sorted_CrdRate_Gini_S9 noobs;Run;*/
2195
2196 proc print data=sorted_CrdRate_Gini_S9 noobs;
2197 var mon / style =[width=3in];
2198 var _freq_ / style =[width=3in];
2199 var gini / style =[width=3in];
2200 run;
NOTE: There were 24 observations read from the data set WORK.SORTED_CRDRATE_GINI_S9.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.14 seconds
user cpu time 0.13 seconds
system cpu time 0.01 seconds
memory 482.62k
OS Memory 74708.00k
Timestamp 06/23/2025 09:57:28 AM
Step Count 310 Switch Count 0
Page Faults 0
Page Reclaims 1360
Page Swaps 0
Voluntary Context Switches 24
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
2201
2202 /***PELET S10-אחוז תפיסה***/
2203 /***PELET S10-אחוז תפיסה***/
76 The SAS System 07:59 Monday, June 23, 2025
2204 /***PELET S10-אחוז תפיסה***/
2205 ods excel options (sheet_name='S10_תפיסה'
2206 sheet_interval="proc"
2207 gridlines = 'yes'
2208 tab_color='white'
2209 );
2210 title;
2211 title1 j=l color=red height=2 'אוכ-יישויות נקיות בעלות ציון כא חיובי';
2212 title2 j=l color=red height=3 'אחוז_תפיסה';
2213 title3 j=l 'לא הוגדר קריטירון להדלקה';
2214
2215 proc print data=sorted_CrdRate_Tfisa_S10 noobs;
2216 var mon / style =[width=14in];
2217 var PCT_Tfisa20 / style =[width=14in];
2218 run;
NOTE: There were 24 observations read from the data set WORK.SORTED_CRDRATE_TFISA_S10.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.05 seconds
user cpu time 0.05 seconds
system cpu time 0.00 seconds
memory 335.46k
OS Memory 74708.00k
Timestamp 06/23/2025 09:57:28 AM
Step Count 311 Switch Count 0
Page Faults 0
Page Reclaims 50
Page Swaps 0
Voluntary Context Switches 14
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
2219
2220 ods excel close;
NOTE: Writing EXCEL file: /usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/Bakara_CrdRate_23JUN2025_09_56_32.xlsx
2221
2222
2223
2224 /****SEND EMAIL****/
2225 /****SEND EMAIL****/
2226 /****SEND EMAIL****/
2227 /****SEND EMAIL****/
2228 FILENAME mail EMAIL
2229 from="Ron.Einstein@BankLeumi.co.il"
2230 TO=("Ron.Einstein@BankLeumi.co.il")
2231 /*TO=("Ron.Einstein@BankLeumi.co.il","Tali.Robinsohn@BankLeumi.co.il","Avital.Noiman@BankLeumi.co.il","Aviad.Klinger@Bank
2231 ! Leumi.co.il","Amit.Shtein@BankLeumi.co.il"ת"Rachel.Sonnino@BankLeumi.co.il")*/
2232 SUBJECT=" --&last_mon_in_Report_YYMM1.-בקרת ציון כא-דוח חודשי"
2233 encoding='utf-8' /**To show Hebrew!!!**/
2234 CONTENT_TYPE="text/plain"
2235 attach=(&path. content_type="excel");
2236 ODS LISTING CLOSE;
2237 /*ODS HTML BODY=mail;*/
2238
2239
77 The SAS System 07:59 Monday, June 23, 2025
2240 data _null_;
2241 file mail;
2242 put 'היי';
2243 put 'מצורף קובץ בקרת ציון כא ובקרות נלוות';
2244 put ' ';
2245 put 'לפלט הוספתי ניתוח מדד גני ואחוז תפיסה';
2246 put ' ';
2247 put "הבקרה רצה בכל חודש ומתווספת לפלט צובר שאליו נוספים נתונים מדי חודש";
2248 put ' ';
2249 put 'גליון בצבע אדום- הדלקה בחודש אחרון';
2250 put ' ';
2251 put 'גליון בצבע כתום- הדלקה בחודש שאיננו חודש אחרון';
2252 put ' ';
2253 put 'גליון בצבע ירוק- אין הדלקה';
2254 put ' ';
2255 put 'הדלקת גליון בפפר נבדקה החל מ2502';
2256 put ' ';
2257 put 'בהמשך יישלח אימייל שמתייחס מילולית לתוצאות';
2258 put ' ';
2259 put ' ';
2260 put 'בברכה, רון אינשטין';
2261 run;
NOTE: The file MAIL is:
E-Mail Access Device
Message sent
To: "Ron.Einstein@BankLeumi.co.il"
Cc:
Bcc:
Subject: -- 2505-בקרת ציון כא-דוח חודשי
Attachments: ( "/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/Bakara_CrdRate_23JUN2025_09_56_32.xlsx" CONTENT_TYPE = "excel"
)
NOTE: 19 records were written to the file MAIL.
The minimum record length was 1.
The maximum record length was 66.
NOTE: DATA statement used (Total process time):
real time 0.21 seconds
user cpu time 0.04 seconds
system cpu time 0.13 seconds
memory 376.56k
OS Memory 34728.00k
Timestamp 06/23/2025 09:57:28 AM
Step Count 312 Switch Count 8
Page Faults 0
Page Reclaims 176
Page Swaps 0
Voluntary Context Switches 74
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
2262
2263
2264 %LET _CLIENTTASKLABEL=;
2265 %LET _CLIENTPROCESSFLOWNAME=;
2266 %LET _CLIENTPROJECTPATH=;
78 The SAS System 07:59 Monday, June 23, 2025
2267 %LET _CLIENTPROJECTPATHHOST=;
2268 %LET _CLIENTPROJECTNAME=;
2269 %LET _SASPROGRAMFILE=;
2270 %LET _SASPROGRAMFILEHOST=;
2271
2272 ;*';*";*/;quit;run;
2273 ODS _ALL_ CLOSE;
2274
2275
2276 QUIT; RUN;
2277
Can you confirm you are using PNG by trying either of the following:
Option 1:
Add the following GOPTIONS statement to the top of your code:
goptions device=PNG;
Option 2:
From the drop down options menu at the top of your SAS Enterprise Guide window, select:
TOOLS -> OPTIONS
Then, on the left hand side under Results, select:
Graph
Then, on the right hand side, set the value of the Graph Format option to:
PNG
Next, below where it says "Options for PNG", enabled the following two options:
Include titles inside the image
Include footnotes inside the image
Then click OK to return to Enterprise Guide.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.