BookmarkSubscribeRSS Feed
Ronein
Onyx | Level 15

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
Kathryn_SAS
SAS Employee

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.

BrianB4233
Obsidian | Level 7
Can confirm that option #2 has worked for me in the past.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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.

Browse our catalog!

Discussion stats
  • 2 replies
  • 397 views
  • 1 like
  • 3 in conversation