Hello everyone, I would like to know if there is a way to hide a specific column from a dataset for certain users while keeping the same dataset accessible in SAS Enterprise Guide. For example, can we prevent a user from viewing a sensitive column (like a salary or ID number) even though they have access to the dataset? ... View more

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 ... View more

A SAS Viya Administration question that I have heard multiple times recently is whether it is possible to perform a partial backup and restore of a SAS Viya environment. In addition to hearing it from colleagues and customers, I also ran into a case where we needed to implement a partial backup in our internal reporting environment. Given the interest, I thought Communities post ... View more

I am trying to create the box plot. I want to customize the x axis label and the Key legend Text. How can I ODS ESCAPECHAR = '^'; ods rtf file = "C:\temp\test.rtf" ; ods graphics on / attrpriority=none reset=all width=8.0in height=4.5in border=off; proc sgplot data=sashelp.class noautolegend; styleattrs datacolors=(lightgreen lightblue) datacontrastcolors=(blue green) datasymbols=(Trianglefilled squarefilled ); vbox height / category=sex groupdisplay=cluster name='vbox' boxwidth=0.2; xaxis label="sex" offsetmax=0.12 labelattrs=(size=9pt weight=bold family='Arial') valueattrs=(weight=bold size=9pt family='Arial'); yaxis label="height" min=-10 max=100 values=(-10 to 100 by 10) labelattrs=(size=10pt weight=bold) valueattrs=(weight=bold size=9pt family='Arial') fitpolicy=none; refline 0 / axis=y lineattrs=(color=grey pattern=3); keylegend 'vbox' / title="sex" location=outside position=bottom valueattrs=(family='Arial' size=10pt) titleattrs=(weight=bold family='Arial' size=10pt) noborder; run; ods rtf close; achieve this? Thank you in advance.   ... View more