Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- Programming
- /
- Programming
- /
- ODS excel -WARNING: Unsupported device 'SVG' for EXCEL destination. Us...
Options
- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Onyx | Level 15
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 06-23-2025 02:59 AM
(450 views)
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
2 REPLIES 2
SAS Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Can confirm that option #2 has worked for me in the past.
The 2025 SAS Hackathon has begun!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
How to Concatenate Values
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.
SAS Training: Just a Click Away
Ready to level-up your skills? Choose your own adventure.
Discussion stats
-
2 replies
-
06-23-2025 02:59 AM
-
451 views
-
1 like
-
3 in conversation
-
