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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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