Hello I want to send an email via sas and have text in body email. I get an email to my outlook but the body is empty.   why?????   options nocenter emailsys=smtp emailhost=smtp.leumi emailport=25 ; FILENAME mail EMAIL TO="<Ron.gggdansk@gmail.com>" FROM="<Ron.gggdansk@gmail.com>" SUBJECT="עדכון פאנל העמדות-CS" CONTENT_TYPE="text/html" encoding="utf-8"; ODS LISTING CLOSE; ODS HTML BODY=mail; proc odstext; p 'היי,'/Style=Header {fontsize=12pt color=black fontstyle=italic just=R}; P ' '; P ' '; P ' '; P ' '; P ' '; p 'בברכה'/Style=Header {fontsize=12pt color=black fontstyle=italic just=R}; p 'משה '/Style=Header {fontsize=12pt color=black fontstyle=italic just=R}; run;  Here is the log 1 The SAS System 08:02 Wednesday, October 15, 2025 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='f_Dynamic_code_V5.sas'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE='M:\a.ריכוז תוכניות\CS\פאנל העמדות_מעודכן-יולי 2025\f_Dynamic_code_V5.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 options 30 nocenter 31 emailsys=smtp 32 emailhost=smtp.leumi 33 emailport=25 34 ; 35 FILENAME mail EMAIL 36 TO="<Ron.Einstein@BankLeumi.co.il>" 37 FROM="<Ron.Einstein@BankLeumi.co.il>" 38 SUBJECT="עדכון פאנל העמדות-CS" 39 CONTENT_TYPE="text/html" 40 encoding="utf-8"; 41 ODS LISTING CLOSE; 42 ODS HTML BODY=mail; NOTE: Writing HTML Body file: MAIL 43 proc odstext; 44 p 'היי,'/Style=Header {fontsize=12pt color=black fontstyle=italic just=R}; 45 P ' '; 46 P "פאנל העמדות עודכן עד העמדות בתאריך &max_Haamada_date."/Style=Header {fontsize=12pt color=black fontstyle=italic 46 ! fontweight=bold just=R }; 47 P ' '; 48 p 'להלן טבלת הפאנל החדשה-'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 48 ! backgroundcolor=lightYellow}; 49 p ' r_r.Panel_Haamadot_CS '/Style=Header {fontsize=12pt color=black fontstyle=italic just=R fontweight=bold 49 ! backgroundcolor=lightYELLOW}; 50 P 'הפאנל מתעדכן בכל יום ומהווה טבלה צוברת של העמדות החל מ01.09.2020 ועד יום עסקים אחרון'/Style=Header {fontsize=12pt 50 ! color=black fontstyle=italic fontweight=bold just=R }; 51 P ' '; 2 The SAS System 08:02 Wednesday, October 15, 2025 52 P ' '; 53 P ' '; 54 P ' '; 55 P 'להלן טבלת עזר שבה אפשר לחפש את כל הבקשות באושרו במנוע של לקוח מסויים'/Style=Header {fontsize=12pt color=black 55 ! fontstyle=italic fontweight=bold just=R backgroundcolor=lightYellow}; 56 P 'זוהי טבלת עזר שתעזור לנו לתחקר מדוע לא נמצאה בקשה תואמת להעמדה בחיתום ממוכן'/Style=Header {fontsize=12pt color=black 56 ! fontstyle=italic fontweight=bold just=R }; 57 P 'r_r.Engine_Process_Vatik_New'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 58 P 'עדיף לחפש לפי נומרטור דאטא ווורהאוס או לפי תז'/Style=Header {fontsize=12pt color=black fontstyle=italic 58 ! fontweight=bold just=R }; 59 P ' '; 60 P ' '; 61 P 'לפי הסיומת של השדות אפשר לדעת את מקור הנתונים'/Style=Header {fontsize=12pt color=black fontstyle=italic 61 ! fontweight=bold just=R backgroundcolor=lightYellow }; 62 P '_H- שדות מסקור ידוע'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 63 P ' בשדות מסקור ידוע יש שוני בין מקרה שהלקוח לא קים בסקור ידוע לבין מצב שהלקוח קיים והשדה עם ערך ריק'/Style=Header 63 ! {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 64 P '_C- שדות מסקור חודש העמדה '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 65 P 'מאחר ובתאריך העמדה סקור חודש העמדה לא פורסם עדיין אז עם פרסום סקור חדש נתוני סקור חודש העמדה מתעדכנים 65 ! רטרואקטיבית'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 66 P '_DP-שדות מדיילי פאנל מתאריך העמדה שמייצגים ניצול בסוף יום העסקים של תאריך העמדה'/Style=Header {fontsize=12pt 66 ! color=black fontstyle=italic fontweight=bold just=R }; 67 P 'ENGINE-שדות מבקשה במנוע שתואמת להעמדה בחיתום ממוכן '/Style=Header {fontsize=12pt color=black fontstyle=italic 67 ! fontweight=bold just=R }; 68 P ' '; 69 P ' '; 70 P 'Sivug_Loans'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 70 ! backgroundcolor=lightYellow }; 71 P 'סיווג העמדות לחיתום ממוכן או ידני'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 71 ! }; 72 P ' יש לציין שהסיווג איננו מדוייק ב100%'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold 72 ! just=R }; 73 P '(A)-חיתום_ממוכן_מבוסס_מנוע '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 74 P '(B)-חיתום_ממוכן_מבוסס_הכינותי_ללא_מנוע'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold 74 ! just=R }; 75 P '(C)-תשלומון/פורס'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 76 P '(D)-קליק_מסחרי '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 77 P '(E)-חיתום_ידני '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 78 P ' '; 79 P ' '; 80 P 'hativa_Time_Haamada'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 80 ! backgroundcolor=lightYellow}; 81 P 'חטיבה נכון לתאריך העמדה'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 82 P ' '; 83 P 'mekushar_C'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 83 ! backgroundcolor=lightYellow}; 84 P ' מקושר מסקור חודש העמדה'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 85 P ' '; 86 P 'mekushar_H'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 86 ! backgroundcolor=lightYellow}; 87 P ' מקושר מסקור ידוע'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 88 P ' '; 89 P ' '; 90 P 'אוכלוסיה'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 90 ! backgroundcolor=lightYellow}; 91 P 'העמדות מטי/מטח ללקוחות מחטיבות 833 703 כולל פפר וללא סינון מקושרים וללא סינון דגמי חובב והוצאות משפטיות'/Style=Header 91 ! {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 92 P 'שיוך חטיבתי ל-803,703 בוצע לפי חטיבה אליה שייך הלקוח נכון לתאריך העמדה'/Style=Header {fontsize=12pt color=black 3 The SAS System 08:02 Wednesday, October 15, 2025 92 ! fontstyle=italic fontweight=bold just=R }; 93 P ' '; 94 P ' '; 95 P 'kv_degem'/Style=Header {fontsize=12pt color=black fontstyle=italic just=R fontweight=bold 95 ! backgroundcolor=lightYELLOW}; 96 P 'שיוך לקבוצת דגם מנתוני הדאטא וורהאוס'/Style=Header {fontsize=12pt color=black fontstyle=italic just=R}; 97 P ' '; 98 P ' '; 99 P ' '; 100 P ' '; 101 P 'בפאנל מוצגות בקשות מאושרות במנוע רק עבור העמדות בחיתום ממוכן מבוסס מנוע'/Style=Header {fontsize=12pt color=black 101 ! fontstyle=italic fontweight=bold just=R }; 102 P ' '; 103 P 'chosen_Offer_Amnt '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 103 ! backgroundcolor=lightYellow }; 104 P 'הצעה במנוע שרלבנטית להעמדה שבוצעה בחיתום ממוכן'/Style=Header {fontsize=12pt color=black fontstyle=italic 104 ! fontweight=bold just=R }; 105 P ' '; 106 P 'Channel_Desc'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 106 ! backgroundcolor=lightYellow }; 107 P 'ערוץ העמדה'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 108 P 'להלן ערוצי העמדה דיגיטלים'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 109 P 'אייפון , אנדרואיד , גלישה ישירה , כספומט חדש , עמדת קהל חיצוני , עמדת קהל סניף , מוביל לבנק הדיגיטלי'/Style=Header 109 ! {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 110 P ' '; 111 P ' '; 112 P 'PRODUCTID_ENGINE'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 112 ! backgroundcolor=lightYellow }; 113 P '(MO)-לקוח עם וותק מעל 3 חודשים וללא מחזור נמוך והצעות מרובות-קליק סטודנטים רכב הסדר שכירים'/Style=Header 113 ! {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 114 P '(UL)-לקוח עם וותק מעל 3 חודשים וללא מחזור נמוך והצעה לקליק בלבד '/Style=Header {fontsize=12pt color=black 114 ! fontstyle=italic fontweight=bold just=R }; 115 P '(AP)-לקוח חדש מזדמן לבקשת הלוואת רכב '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold 115 ! just=R }; 116 P '(CP)-לקוח עם וותק מעל 3 ח עם מחזור נמוך '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold 116 ! just=R }; 117 P '(NC)-לקוח חדש-מזדמן או פתח כבר חן ועברו עד 3 ח '/Style=Header {fontsize=12pt color=black fontstyle=italic 117 ! fontweight=bold just=R }; 118 P '(BL)-אשראי בקליק מסחרי '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 119 P ' '; 120 P ' '; 121 P 'ROUTING_ENGINE'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 121 ! backgroundcolor=lightYellow }; 122 P '(ACCEPT)תהליך קליק עבר בהצלחה '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 123 P '(BUREAU)נוצרה בקשה כפולה עקב פנייה למאגר אשראי '/Style=Header {fontsize=12pt color=black fontstyle=italic 123 ! fontweight=bold just=R }; 124 P '(DECLINE)תהליך קליק נדח '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 125 P '(FAILURE)-תקלה בתהליך קליק עקב תקלה במנוע או תקלה בדוח המלא ממאגר אשראי '/Style=Header {fontsize=12pt color=black 125 ! fontstyle=italic fontweight=bold just=R }; 126 P '(REFER)תהליך קליק הופנה לסניף וזה למעשה כמו דחייה '/Style=Header {fontsize=12pt color=black fontstyle=italic 126 ! fontweight=bold just=R }; 127 P ' '; 128 P ' '; 129 P 'בפאנל קיימים נתונים מהמקורות הבאים'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold 129 ! just=R backgroundcolor=lightYellow}; 130 P ' א-נתוני העמדה מהדאטא וורהאוס כגון מזהה הסכם הלוואה,תאריך העמדה,שעת העמדה, סכום העמדה,סוג הלוואה, מטבע 130 ! הלוואה,ריבית,מרווח מפריים,מספר תשלומים,תאריך סיום מתוכנן וכו'/Style=Header {fontsize=12pt color=black fontstyle=italic 130 ! fontweight=bold just=R }; 4 The SAS System 08:02 Wednesday, October 15, 2025 131 P ' ב-מאפיני לקוח נכון לתאריך העמדה מהדאטא וורהאוס-לקוח, סניף, חטיבה ,מערך וכו'/Style=Header {fontsize=12pt color=black 131 ! fontstyle=italic fontweight=bold just=R }; 132 P 'ג-מאפיני הלקוח מסקור ידוע כגון עושר ניצול דירוג וכו'/Style=Header {fontsize=12pt color=black fontstyle=italic 132 ! fontweight=bold just=R }; 133 P 'ד-נתוני קובץ הכינותי קובץ שהיה זמין נכון לתאריך העמדה'/Style=Header {fontsize=12pt color=black fontstyle=italic 133 ! fontweight=bold just=R }; 134 P 'ה-נתוני בקשה במנוע שקשורה להעמדה שבוצעה וזה רק עבור העמדות בחיתום ממוכן מבוסס מנוע'/Style=Header {fontsize=12pt 134 ! color=black fontstyle=italic fontweight=bold just=R }; 135 P 'ו-נתוני דיילי פאנל- לשליפת ניצול הלקוח לאחר העמדה לצורך חישוב מיצוי לאחר העמדה '/Style=Header {fontsize=12pt 135 ! color=black fontstyle=italic fontweight=bold just=R }; 136 P ' '; 137 P ' '; 138 P 'באופן כללי אפשר לחלק את העמדות ל-4 קבוצות'/Style=Header {fontsize=12pt color=black fontstyle=italic 138 ! fontweight=bold just=R backgroundcolor=lightYellow}; 139 P 'א-העמדות בחיתום ממוכן שמבוצעות מתוך הגדרה ללא מנוע- תשלומון /פורס'/Style=Header {fontsize=12pt color=black 139 ! fontstyle=italic fontweight=bold just=R }; 140 P 'ב-העמדות בחיתום ממוכן מבוסס מנוע '/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 140 ! }; 141 P 'ג-העמדות בחיתום ממוכן שבוצעו בהתבסס על הכינותי ללא מנוע בשל תקלה במנוע '/Style=Header {fontsize=12pt color=black 141 ! fontstyle=italic fontweight=bold just=R }; 142 P 'ד-העמדות בחיתום ידני כלומר הפקיד בבנק קבע את מאפיני ההלוואה-סכום,מספר תשלומים,ריבית וייתכן שהסתייע גם במנוע אך 142 ! ההחלטה היא של הפקיד'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 143 P ' '; 144 P ' '; 145 P 'חיתום ממוכן יכול להתבצע באופן הבא'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 145 ! backgroundcolor=lightYellow}; 146 P 'א-על ידי הלקוח באממצעים דיגיטליים ללא מגע יד פקיד '/Style=Header {fontsize=12pt color=black fontstyle=italic 146 ! fontweight=bold just=R }; 147 P 'ב-יש מגע של פקיד בהעמדה אך הפקיד לא מחליט שום דבר והעמדה מתבצעת באופן דיגיטלי לפי מה שהמנוע קבע'/Style=Header 147 ! {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R }; 148 P 'ג-יש מגע של פקיד בהעמדה והפקיד חייב לא לחרוג בסכום ומספר תשלומים שקבע המנוע אך כן יכול לשפר את הריבית שהציע 148 ! המנוע-זהו חיתום ממוכן לא מלא משום שהפקיד שיפר את הריבית לעומת מה שהמנוע קבע'/Style=Header {fontsize=12pt color=black 148 ! fontstyle=italic fontweight=bold just=R }; 149 P ' אין לנו יכולת לזהות את המקרה הזה'/Style=Header {fontsize=12pt color=black fontstyle=italic fontweight=bold just=R 149 ! }; 150 P ' '; 151 P ' '; 152 P ' '; 153 p 'בברכה'/Style=Header {fontsize=12pt color=black fontstyle=italic just=R}; 154 p 'רון אינשטין'/Style=Header {fontsize=12pt color=black fontstyle=italic just=R}; 155 run; NOTE: PROCEDURE ODSTEXT used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds memory 924.68k OS Memory 34468.00k Timestamp 10/15/2025 03:13:53 PM Step Count 788 Switch Count 0 Page Faults 0 Page Reclaims 211 Page Swaps 0 Voluntary Context Switches 8 Involuntary Context Switches 3 Block Input Operations 0 Block Output Operations 0 5 The SAS System 08:02 Wednesday, October 15, 2025 156 157 %LET _CLIENTTASKLABEL=; 158 %LET _CLIENTPROCESSFLOWNAME=; 159 %LET _CLIENTPROJECTPATH=; 160 %LET _CLIENTPROJECTPATHHOST=; 161 %LET _CLIENTPROJECTNAME=; 162 %LET _SASPROGRAMFILE=; 163 %LET _SASPROGRAMFILEHOST=; 164 165 ;*';*";*/;quit;run; 166 ODS _ALL_ CLOSE; Message sent To: "<Ron.Einstein@BankLeumi.co.il>" Cc: Bcc: Subject: עדכון פאנל העמדות-CS Attachments: 167 168 169 QUIT; RUN; 170 ... View more

Hello I want to perform full merge of two data sets. I want to define the rule- If customer  exist in one table then take Y information from this table. IF customer exit in both tables then do as following- IF Y value is not null in both tables then take it from table aa IF Y value is  null in one  table  then take Y value from the table where it is not null     what is the way to do it via data step? what is the way to do it via proc sql? data aa; input CustID y; cards; 111 . 222 20 444 50 555 70 123 35 ; run; data bb; input CustID y; cards; 111 15 222 20 333 35 444 . 666 80 123 27 ; run; proc sort data=aa; by CustID;Run; proc sort data=bb; by CustID;Run; data want; merge aa bb; by CustID; Run; ... View more

Hello In my data set there are two time fields. With my eyes I see same time in both fields. I calculate difference between them (difference time in seconds) and I expect to get 0 but I get positive number proc sql; create table a as select Matefet_Offer_Time,application_Time,Matefet_Offer_Time-application_Time as dif from ttt_A1e where Agreement_Account_Id=649012587 ; quit;   ... View more

Hello Lets say that I am working in sas and select data from teradata table view. I know 2 ways that are working 100% well proc sql; connect to teradata (server=dwprod schema=DWP_vall authdomain=TeraDataAuth); create table WAY1 as select * from connection to teradata ( select top 5 * from VBM374_USED_BRANCH_CUSTOMER ); disconnect from teradata; quit ; proc sql outobs=5; create table WAY2 as select * from teradata.VBM374_USED_BRANCH_CUSTOMER ; quit; The connection between sas and tera was done by sas admin. As I understand Way1 is connection to teradata and here MUST use Teradata SQL functions  (such as QUALIFY,RANK,OVERmpartition,row_number)     As I understand  Way2 is via libname statement and here MUST use SAS language (Access Teradata Table Using LIBNAME Statement) My question-How can I know what is the libaname  code that connect between sas and tera here??? I dont need to run the libaname in order to run it but I think that in background it is running but I dont know what  libname is running .   At beginning I run include  %include '!RSMEHOME/SASCode/SHARECode/Libname.sas'; Here is the log or running the include 1 The SAS System 09:02 Saturday, September 20, 2025 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 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 %include '!RSMEHOME/SASCode/SHARECode/Libname.sas'; NOTE: Libref RET_EXT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/ABT_Retail_SME/ETL_DataMart/Extract NOTE: Libref RET_DM refers to the same physical library as RET_DM. NOTE: Libref RET_DM was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/ABT_Retail_SME/ETL_DataMart/DataMart NOTE: Libref ABT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/ABT_Retail_SME/ETL_ABT/ABT NOTE: Libref INOUTCOM was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/income_outcome NOTE: Libref MEMUZAG was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/memuzag NOTE: Libref CATALOG was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/catalog NOTE: Libref EXTRA was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/extra NOTE: Libref NIKUD refers to the same physical library as A38. NOTE: Libref NIKUD was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/A38 NOTE: Libref BAKASHOT was successfully assigned as follows: Engine: V9 2 The SAS System 09:02 Saturday, September 20, 2025 Physical Name: /usr/local/SAS/MidulOld/score_cs/bakashot NOTE: Libref HALV was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/halv NOTE: Libref ITHALV was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/ithalv NOTE: Libref HOVAV was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/hovav NOTE: Libref BTCHONOT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/btchonot NOTE: Libref HAFRASHA was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/hafrasha NOTE: Libref SHELANU was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/shelanu NOTE: Libref NUMAIN was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/numaIn NOTE: Libref NUMAOUT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/numaOut NOTE: Libref NWSCRCB was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld_CB/score_cb/Nwscrcb NOTE: Libref CB_TAN was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld_CB/score_cb/cb_tan NOTE: Libref PAN_TAN was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/pan_tan NOTE: Libref EXT_TAN was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/ext_tan NOTE: Libref SIKUN was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/dohot_cs/sikun/output NOTE: Libref DOHOT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/dohot NOTE: Libref LGDBLL was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/LGDBll NOTE: Libref LGDCB was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/LGDCB NOTE: Libref LGD was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs NOTE: Libref DRGSYS was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/drgsys NOTE: Libref RISKCONT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/riskcont 3 The SAS System 09:02 Saturday, September 20, 2025 NOTE: Libref DATACS was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/dataCS NOTE: Libref OUTCS was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/outCS NOTE: Libref A38 refers to the same physical library as NIKUD. NOTE: Libref A38 was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/A38 NOTE: Libref CATALOG was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/catalog NOTE: Libref MEMUZAG was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/memuzag NOTE: Libref BTCHONOT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/btchonot NOTE: Libref PAN_TAN was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/pan_tan NOTE: Libref TXT_CSV was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/txt_csv NOTE: Libref DOHOT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/dohot NOTE: Libref BDIKOT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/dohot/bdikot NOTE: Libref LGDBLL was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/LGDbll NOTE: Libref EADCS was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/Eadcs NOTE: Libref LOG was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOldARV/Log NOTE: Libref T_AVODA was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/t_avoda NOTE: Libref MODELCB was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld_CB/score_cb/General/Model_CB NOTE: Libref SASTAB was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/PARETO/BAKASHOT_SHONOT_SIGAL/SASTAB NOTE: Libref NWSCRCB was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld_CB/score_cb/Nwscrcb NOTE: Libref CATALOG was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/catalog NOTE: Libref ARCBDATA was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOldARV_CB/score_cb/arcbdata 4 The SAS System 09:02 Saturday, September 20, 2025 NOTE: Libref RET_EXT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/ABT_Retail_SME/ETL_DataMart/Extract NOTE: Libref ORLY was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/Orly NOTE: Libref APP was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/SASData/app NOTE: Library SAM does not exist. NOTE: Libref CB_1AD5 was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/cb_1ad5 NOTE: Libref TEST was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/test NOTE: Libref EAD_CS was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/EAD_CS NOTE: Library SIM_IKL does not exist. NOTE: Library CRA does not exist. NOTE: Library USERDIRC does not exist. NOTE: Libref AYELET was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/ayelet NOTE: Libref KARINA was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/karina NOTE: Libref NATALYA was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/Natalya NOTE: Libref KFIR was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/kfir NOTE: Libref BCG was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/bcg NOTE: Libref R_R was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/R_R NOTE: Libref TSUA_HON was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/TSUA_HON NOTE: Libref CSPITUAH was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/SASData/cspituah NOTE: Library DATA does not exist. NOTE: Library ABTCS does not exist. NOTE: Libref MALMASH was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/kfir/Malmash NOTE: Libref BALMASH was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/Balmash NOTE: Library BACKTEST does not exist. NOTE: Library BTABLES does not exist. NOTE: Libref CS was successfully assigned as follows: Engine: V9 5 The SAS System 09:02 Saturday, September 20, 2025 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users NOTE: Library DIR_CB does not exist. NOTE: Library DIR_CS does not exist. NOTE: Libref HADATZ3 was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld_CB/score_cb/MF/MF2NT NOTE: Libref ABT_CS was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/ABT_CS NOTE: Library ECLIB000 does not exist. NOTE: Libref ARVIDKUN was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOldARV/score_cs/arvidkun NOTE: Library SASTAB does not exist. NOTE: Libref SASTAB was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/PARETO/BAKASHOT_SHONOT_SIGAL/SASTAB NOTE: Libref BDI_CB was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/BDI_CB NOTE: Libref M_HOVAV was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/SASData/M_HOVAV NOTE: Libref MAARAHIM was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/SASData/MAARAHIM NOTE: Libref NWSCRCB was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld_CB/score_cb/Nwscrcb NOTE: Libref CATALOG was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOld/score_cs/catalog NOTE: Libref ARCBDATA was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/MidulOldARV_CB/score_cb/arcbdata NOTE: Libref RET_EXT was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/ABT_Retail_SME/ETL_DataMart/Extract NOTE: Libref SAPIM was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/SASData/sapim NOTE: Libref PANELTZ was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/SASCSB/MidulOld/score_cs/panel_tz NOTE: Libref CB_1AD5 was successfully assigned as follows: Engine: V9 Physical Name: /usr/local/SAS/SASUsers/LabRet/SASData/CB_1AD5 153 154 155 %LET _CLIENTTASKLABEL=; 156 %LET _CLIENTPROCESSFLOWNAME=; 157 %LET _CLIENTPROJECTPATH=; 158 %LET _CLIENTPROJECTPATHHOST=; 159 %LET _CLIENTPROJECTNAME=; 160 %LET _SASPROGRAMFILE=; 161 %LET _SASPROGRAMFILEHOST=; 162 163 ;*';*";*/;quit;run; 6 The SAS System 09:02 Saturday, September 20, 2025 164 ODS _ALL_ CLOSE; 165 166 167 QUIT; RUN; 168     ... View more

Hello Lets say that I want to check when a teadata view table was lastly updated. If I run the following query in teradata then I get the answer    Select TableName , CreatorName, CreateTimeStamp, LastAlterName, LastAlterTimeStamp, AccessCount, LastAccessTimeStamp from DBC.Tables Where upper(DataBaseName) = 'DWP_VALL' And TAblename= 'VBM374_USED_BRANCH_CUSTOMER' My question-  Lets say that I want to work on sas and run the query in  sas . If I run this query then it is working so I know that this connector is working well proc sql; connect to teradata (server=dwprod schema=DWP_vall authdomain=TeraDataAuth); create table VBM374_USED_BRANCH_CUSTOMER as select * from connection to teradata ( select top 10 * from VBM374_USED_BRANCH_CUSTOMER ); disconnect from teradata; quit ; But if i run  the query that check last time updated via sas then i get error ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine. proc sql; connect to teradata (server=dwprod schema=DWP_vall authdomain=TeraDataAuth); create table WANT as select * from connection to teradata ( Select TableName , CreatorName, CreateTimeStamp, LastAlterName, LastAlterTimeStamp, AccessCount, LastAccessTimeStamp from DBC.Tables Where upper(DataBaseName) = 'DWP_VALL' And TAblename= 'VBM374_USED_BRANCH_CUSTOMER' ); disconnect from teradata; quit ;   Here is full  log of error 1 The SAS System 09:02 Saturday, September 20, 2025 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 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 proc sql; 30 connect to teradata (server=dwprod schema=DWP_vall authdomain=TeraDataAuth); 31 create table WANT as 32 select * from connection to teradata 33 ( 34 Select TableName , CreatorName, CreateTimeStamp, LastAlterName, LastAlterTimeStamp, AccessCount, LastAccessTimeStamp 35 from DBC.Tables 36 Where upper(DataBaseName) = 'DWP_VALL' 37 And TAblename= 'VBM374_USED_BRANCH_CUSTOMER' 38 ); ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 39 disconnect from teradata; NOTE: Statement not executed due to NOEXEC option. 40 quit ; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.53 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 204.84k OS Memory 24472.00k Timestamp 09/21/2025 10:02:33 AM Step Count 21 Switch Count 18 Page Faults 0 Page Reclaims 34 Page Swaps 0 Voluntary Context Switches 125 2 The SAS System 09:02 Saturday, September 20, 2025 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 0 41 42 43 %LET _CLIENTTASKLABEL=; 44 %LET _CLIENTPROCESSFLOWNAME=; 45 %LET _CLIENTPROJECTPATH=; 46 %LET _CLIENTPROJECTPATHHOST=; 47 %LET _CLIENTPROJECTNAME=; 48 %LET _SASPROGRAMFILE=; 49 %LET _SASPROGRAMFILEHOST=; 50 51 ;*';*";*/;quit;run; 52 ODS _ALL_ CLOSE; 53 54 55 QUIT; RUN; 56   ... View more

Hello Is it possible that data sets in work libarary be listed in order that they were created? I look at work libarary nd I see the data sets there but the order they appear is alphabetic  and not by time they were created     ... View more

Hello Lets say I have a macro variable with values separated by '+'   Lets say that I want to pass the values in macro var into sas data set. Please note that number of arguments in the macro var can be different so I am looking for dynamic solution that can do it for each number of arguments in macro var. Here is an example for the wanted data set based on the macro var list %let List=Health+Wealth+age+Education_in_Years+Ind_SPort_Lover; Data Want; input VAR_Name $20.; cards; Health Wealth age Education_in_Years Ind_Sport_Lover ; Run;     ... View more

Hello Lets say I have list of variables names  in a macro variable separated  by '+'. Lets say that I want to run macro that run on each of the variables. What is the way to do it  please via code that do it automatically? %let numeric_Vars= a_Shir_SmlHov_Pigur+ a_Shir_AKM_HZRHIUV+ a_Shir_Vetek_age_Balut+ a_CDO_ExCC_mx_pos_prob ; /**Want to run this***/ %inf_value(ttt,information_value,a_Shir_SmlHov_Pigur,Ind_Failure); %inf_value(ttt,information_value,a_Shir_AKM_HZRHIUV,Ind_Failure); %inf_value(ttt,information_value,a_Shir_Vetek_age_Balut,Ind_Failure); %inf_value(ttt,information_value,a_CDO_ExCC_mx_pos_prob ,Ind_Failure); ... View more

Hello Let's say I have a data set in long structure. for each customer ID +loan need to calculate max offer in last 7 days prior to loan date What is the way to do it? For example for customer 111 there us one loan and max 7 days before is 22000( offer in 01jul is not relevant because more than 7 days). For customer 222 loan 13000 max offer is 40000 and for loan 35000 max is 28000 ( Offer 40000 is not taking into account because more than 7 days prior loan) In desire table will have 3 rows because have 3 loans. What is way yo do it??   Data have; Format date ddmmyy10.; Input custid date :date9. loansAmnt offerAmnt; Cards; 111 01JUL2025 . 50000 111 03jul2025 . 22000 111 08jul2025 . 19000 111 09jul2025 5000 . 222 01jul2025 . 40000 222 03jul2025 . 28000 222 04jul2025 13000 . 222 08jul2025 . 27000 223 09jul2025 35000 . ; Run: ... View more

Hello I have 2 tables- loans tables (loans that customer take) and offer table (offers that customer get on digital). Note that customer can take loan on digital or in branch (so if take in branch then it might happens that no have digital offer). I combine these 2 tables in order to see all events of loans and offers together in one table.   My task- I want to calculate for each loan what was the relevant offer the customer received 7 days before the loan (included day of loan).   In the case that customer has one loan then it is very simple and just check  offers 7 days before loan and take max of them.   In the case that customer has more than one loan then it is more complicated and here are the rules- Look at offers 7 days prior to loan(included day of loan) If other loan occurred before then all offers till previous loan are not relevant for the offer for this loan   Here is desired table: Need to create column -Relevant_offer_to_loan     Data loans_tbl; format date_Loan ddmmyy10.; Input CUSTID date_Loan :date9. Loan_Amnt; cards; 111 08JUL2025 30000 222 17JUL2025 15000 222 20JUL2025 10000 333 28JUL2025 17000 444 02JUL2025 5000 444 03JUL2025 12000 444 29JUL2025 18000 555 14JUL2025 38000 555 15JUL2025 30000 555 27JUL2025 18000 555 01JUL2025 100000 ; Run; Data offers_tbl; format date_offer ddmmyy10.; Input CUSTID date_offer :date9. Offer_Amnt; cards; 111 02JUL2025 20000 111 05JUL2025 20000 111 06JUL2025 40000 111 09JUL2025 8000 111 28JUL2025 15000 222 15JUL2025 15000 222 18JUL2025 40000 333 22JUL2025 20000 444 02JUL2025 7000 444 28JUL2025 50000 555 05JUL2025 50000 555 09JUL2025 48000 555 10JUL2025 55000 555 14JUL2025 38000 555 22JUL2025 20000 555 27JUL2025 18000 ; Run; proc sql; create table want1 as select COALESCE(a.CUSTID,b.CUSTID) as CUSTID, COALESCE(date_Loan,date_offer) as date format=ddmmyy10., a.Loan_Amnt, b.Offer_Amnt from loans_tbl as a full join offers_tbl as b on a.date_Loan=b.date_offer and a.CUSTID=b.CUSTID order by calculated CUSTID,calculated date ; quit;     ... View more