Hello, Happy New Year to All!   I wanted to ask assistance in adjusting the below code,  I'm trying to get Weekdates for 2024 that ends in Tuesdays.     below is the code I am using and I am not getting the first week of this year which is 01/02/2024, can someone look into it? thanks a lot.   *Report uses Tuesday's EOD inventory; data WeekDates; *Preparing a list of holidays that land on a Tuesday and a list of Mondays to use in lieu of; if _N_ = 0 then do; %let HOLIDAYS =; %let PROXY_DAYS =; array STAT_HOLIDAY[4] $9. _temporary_ ('newyear', 'canada', 'christmas', 'boxing'); do YEAR=&BEGIN_YEAR to &END_YEAR; do i=1 to 4; if weekday(holiday(STAT_HOLIDAY[i],YEAR)) = 3 then do; call symputx('HOLIDAYS',catx(', ',resolve('&HOLIDAYS'),"'"||put(holiday(STAT_HOLIDAY[i],YEAR),mmddyy10.)||"'")); call symputx('PROXY_DAYS',catx(', ',resolve('&PROXY_DAYS'),"'"||put(intnx('day',holiday(STAT_HOLIDAY[i],YEAR),-1),mmddyy10.)||"'")); end; end; end; end; *Check if the first day of the year is in the same week as any dates in the previous year. If so, SAS will treat this week as week zero, so bump the week up by 1 to accommodate; if week(intnx('week',intnx('year',mdy(1,1,&END_YEAR),0),0)+2) = 1 then do i=0 to 52; /*** changed from =0 to =1 to reflect first week of 2023 ***/ WEEK=i+1; do j=1 to 4; *Check if the PORTFOLIO_WEEK will be a holiday, which will cause dips in the data due to stores being closed; if holiday(STAT_HOLIDAY[j],&END_YEAR) = intnx('week',mdy(1,1,&END_YEAR),i)+2 then do; *If Tuesday is a holiday, use the previous day, i.e. Monday's EOD inventory instead; PORTFOLIO_WEEK = intnx('week',mdy(1,1,&END_YEAR),i)+1; *Leave the DO loop as soon as there is a TRUE condition, otherwise it could overwrite on the subsequent iteration; leave; end; else PORTFOLIO_WEEK = intnx('week',mdy(1,1,&END_YEAR),i)+2; end; output; end; else do i=1 to 52; WEEK=i; do j=1 to 4; if holiday(STAT_HOLIDAY[j],&END_YEAR) = intnx('week',mdy(1,1,&END_YEAR),i)+2 then do; PORTFOLIO_WEEK = intnx('week',mdy(1,1,&END_YEAR),i)+1; leave; end; else PORTFOLIO_WEEK = intnx('week',mdy(1,1,&END_YEAR),i)+2; end; output; end; format PORTFOLIO_WEEK mmddyy10.; drop i j year; run; ... View more

Hi,    Hope everybody is doing well.  I just want to ask if someone can look at the code I wrote if it's correct and if there's a way to shorten it.   Thanks in advance,   below is the code:   data Cust_Loc; set Cust_wLoans2 (drop=Dist); if Store_Is_Open = 0 then do;   if (LOC_Inst_loc in (&closed_loc) or LOc_Inst_loc in (&web_loc)) and PDL_Loc = . and Service_Loc = . then Home_Branch = nearest_location; if (LOC_Inst_loc in (&closed_loc) or LOc_Inst_loc in (&web_loc)) and PDL_Loc ne . and Service_Loc = . then Home_Branch = nearest_location; if (LOC_Inst_loc in (&closed_loc) or LOc_Inst_loc in (&web_loc)) and PDL_Loc ne . and Service_Loc ne . then Home_Branch = nearest_location; if (LOC_Inst_loc in (&closed_loc) or LOc_Inst_loc in (&web_loc)) and PDL_Loc = . and Service_Loc ne . then Home_Branch = nearest_location;   if (LOC_Inst_loc not in (&closed_loc) and LOc_Inst_loc not in (&web_loc)) and PDL_Loc = . and Service_Loc = . then Home_Branch = LOC_Inst_Loc; if (LOC_Inst_loc not in (&closed_loc) and LOc_Inst_loc not in (&web_loc)) and PDL_Loc ne . and Service_Loc = . then Home_Branch = LOC_Inst_Loc; if (LOC_Inst_loc not in (&closed_loc) and LOc_Inst_loc not in (&web_loc)) and PDL_Loc ne . and Service_Loc ne . then Home_Branch = LOC_Inst_Loc; if (LOC_Inst_loc not in (&closed_loc) and LOc_Inst_loc not in (&web_loc)) and PDL_Loc = . and Service_Loc ne . then Home_Branch = LOC_Inst_Loc;   if LOC_Inst_Loc = . and (PDL_Loc in (&closed_loc) or PDL_Loc in (&web_loc)) and Service_Loc = . then Home_Branch = nearest_location; if LOC_Inst_Loc = . and (PDL_Loc in (&closed_loc) or PDL_Loc in (&web_loc)) and Service_Loc ne . then Home_Branch = nearest_location;   if LOC_Inst_Loc = . and (PDL_Loc not in (&closed_loc) and PDL_Loc not in (&web_loc)) and Service_Loc = . then Home_Branch = PDL_Loc; if LOC_Inst_Loc = . and (PDL_Loc not in (&closed_loc) and PDL_Loc not in (&web_loc)) and Service_Loc ne . then Home_Branch = PDL_Loc;   if LOC_Inst_Loc = . and PDL_Loc = . and Service_Loc in (&closed_loc) then Home_Branch = nearest_location; if LOC_Inst_Loc = . and PDL_Loc = . and Service_Loc not in (&closed_loc) then Home_Branch = Service_Loc;   end;   if Store_Is_Open = 1 then do;   if (LOC_Inst_Loc ne . and LOC_Inst_Loc not in (&web_loc)) and PDL_Loc = . and Service_Loc = . then Home_Branch = LOC_Inst_Loc; if (LOC_Inst_Loc ne . and LOC_Inst_Loc not in (&web_loc)) and PDL_Loc ne . and Service_Loc = . then Home_Branch = LOC_Inst_Loc; if (LOC_Inst_Loc ne . and LOC_Inst_Loc not in (&web_loc)) and PDL_Loc ne . and Service_Loc ne . then Home_Branch = LOC_Inst_Loc;   if LOC_Inst_loc = . and (PDL_Loc ne . and PDL_loc not in (&web_loc)) and Service_loc = . then Home_Branch = PDL_Loc; if LOC_Inst_loc = . and (PDL_Loc ne . and PDL_loc not in (&web_loc)) and Service_loc ne . then Home_Branch = PDL_Loc;   if LOC_Inst_loc = . and PDL_Loc = . and (Service_loc ne . and Service_loc not in (&web_loc)) then Home_Branch = Service_loc;   if (LOC_Inst_Loc ne . and LOC_Inst_Loc in (&web_loc)) and PDL_Loc = . and Service_Loc = . then Home_Branch = nearest_location; if (LOC_Inst_Loc ne . and LOC_Inst_Loc in (&web_loc)) and PDL_Loc ne . and Service_Loc = . then Home_Branch = nearest_location; if (LOC_Inst_Loc ne . and LOC_Inst_Loc in (&web_loc)) and PDL_Loc ne . and Service_Loc ne . then Home_Branch = nearest_location;   if LOC_Inst_loc = . and (PDL_Loc ne . and PDL_loc in (&web_loc)) and Service_loc = . then Home_Branch = nearest_location; if LOC_Inst_loc = . and (PDL_Loc ne . and PDL_loc in (&web_loc)) and Service_loc ne . then Home_Branch = nearest_location;   if (LOC_Inst_Loc ne . and LOC_Inst_Loc not in (&web_loc)) and PDL_Loc = . and Service_Loc ne . then Home_Branch = LOC_Inst_Loc; if (LOC_Inst_Loc ne . and LOC_Inst_Loc in (&web_loc)) and PDL_Loc = . and Service_Loc ne . then Home_Branch = Service_Loc;   if LOC_Inst_Loc = . and PDL_Loc = . and Service_Loc = . then Home_Branch = nearest_location;   if (LOC_Inst_Loc ne . and LOC_Inst_Loc in (&closed_loc)) and PDL_Loc = . and Service_Loc = . then Home_Branch = Nearest_Location; if (LOC_Inst_Loc ne . and LOC_Inst_Loc in (&closed_loc)) and PDL_Loc ne . and Service_Loc = . then Home_Branch = Nearest_Location; if (LOC_Inst_Loc ne . and LOC_Inst_Loc in (&closed_loc)) and PDL_Loc ne . and Service_Loc ne . then Home_Branch = Nearest_Location; if (LOC_Inst_Loc ne . and LOC_Inst_Loc in (&closed_loc)) and PDL_Loc = . and Service_Loc ne . then Home_Branch = Nearest_Location;   if LOC_Inst_loc = . and (PDL_Loc ne . and PDL_loc in (&closed_loc)) and Service_loc = . then Home_Branch = Nearest_Location; if LOC_Inst_loc = . and (PDL_Loc ne . and PDL_loc in (&closed_loc)) and Service_loc ne . then Home_Branch = Nearest_Location;   if LOC_Inst_Loc in (&web_loc) and PDL_Loc = . and Service_Loc in (&closed_loc) then Home_Branch = Nearest_Location;   end;   format Home_Branch best.; ;run;   ... View more

Hi, how to extract date from this type of date ' 2018-08-26 17:51:30.8770000 +00:00'?   Thank you. ... View more

Hi,   I have the data below and I want to transpose this using 'PAST_DUE' as column.  Can someone please help? thanks a lot! Location PAST_DUE PORTFOLIO_AMT 1001 1-30 Days 917743.04 1002 121-150 Days 2064.4 1003 151-180 Days 862.5 1004 181+ Days 10851.06 1005 31-60 Days 437245.32 1006 61-90 Days 310566.7 1007 91-120 Days 14462.44 1008 Aged Gross Charge Off 300924.87 1009 Current 21937142.14 1010 Gross Charge Off 604973.24 1011 Interest Income 1254249.72 1012 Net Charge Off 418241.37 1013 Non-Aged Gross Charge Off 101701.38 1014 1-30 Days 673340.37 1015 121-150 Days 11531.73 1016 151-180 Days 11231.39 1017 181+ Days 34851.08 1018 31-60 Days 301053.51 1019 61-90 Days 238534.36 1020 91-120 Days 32746.51 1021 Aged Gross Charge Off 195522.19 1022 Current 16515694.87 1023 Gross Charge Off 497445.05 1024 Interest Income 976155.1 1025 Net Charge Off 314109.44 1026 Non-Aged Gross Charge Off 98835.61 1027 1-30 Days 810896.25 1028 121-150 Days 32545.81 1029 151-180 Days 17769.4 1030 181+ Days 18107.64 1031 31-60 Days 415263.76 1032 61-90 Days 314093.92 1033 91-120 Days 54125.37 1034 Aged Gross Charge Off 259291.43 1035 Current 19451736.13 1036 Gross Charge Off 506609.35 1037 Interest Income 1056621.56 1038 Net Charge Off 374537.79 1039 Non-Aged Gross Charge Off 97618.86     Want: Location 1-30 Days 121-150 Days 151-180 Days 181+ Days 31-60 Days 61-90 Days 91-120 Days Aged Gross Charge Off Current Gross Charge Off Interest Income Net Charge Off Non-Aged Gross Charge Off 1001 917743 2064.4 862.5 10851.06 437245.3 310566.7 14462.44 300924.9 21937142 604973.2 1254250 418241.4 101701.4   ... View more

hello,   hope all is good.  I want to use an if else then do statement to generate 1, 0 and blank on a data step with the below data,  I am getting a road block as my statements are not correct.  can someone assist? thanks a lot.   EMAIL_ADDR HomePh CellPhn CONSENT_END_DATE myemail@gmail.com 1234567890 9876543210   myemail@gmail.com 1234567890 9876543210   myemail@gmail.com 1234567890 9876543210 12Aug2017 12:19:22.237 myemail@gmail.com 1234567890 9876543210 12Aug2017 12:19:22.237 myemail@gmail.com 1234567890 9876543210 28Feb2018 10:29:18.003 myemail@gmail.com 1234567890 9876543210 28Feb2018 10:29:18.003   this is the data step that I have:     data Optin; set test; if Email_Addr ~= . then do; if Email_Addr = . then Email_OptIn = ''; else if Email_Addr = Channel_Value and Consent_End_Date ~= . then EMail_OptIn = 1; else if Email_Addr ~= . and Channel_value ~= . and Consent_End_Date = . then Email_OptIn = 1; end; run;     I want to do this for email_addr, HomePhone and Cell Phone. ... View more

hello,   I just want to ask if somebody know how to incorporate the below function in sas, thanks a lot!   cross apply FN_Spell_LoanApp_STATUS_TVF(la.status) s ... View more

Hi,   Hope all is well.   Does anybody have an email code where in if there is data an email will send with attachment and if there is no data just an email saying 'no data to report'?   Thank you in advance. ... View more

hello, hope all is well.   Can someone help in converting the example below to 'Date' in sas, thank you.   Character Date Value: 2023-02-16 03:06:32.9088697 -05:00 ... View more

Hi, Hope all is well.  Can anyone help out with regards to the warning statement below? thanks a lot.   357        proc summary data = have nway missing; 358        class business_state loan_date; 359        var loan_count; 360        output out = final (drop = _type_ _freq_ loan_date_entered) sum=; 361        run;   WARNING: The variable loan_date_entered in the DROP, KEEP, or RENAME list has never been referenced. ... View more

Hello, hope everyone is alright.   I just want to ask if someone has a ready code on how to stop sending an email with attachment when there's error in the data steps, instead send an 'error' email to myself. I have written the below code but it's not working.   %if &syscc=0 %then %do; proc export data=Test_List dbms=xlsx replace outfile='\\SAS_WIP\Test_List'; sheet='Sheet1'; run; filename mymail email 'myemail@email.com' from='myemail <myemail@email.com>' subject='Test List' attach=("\\SAS_WIP\Test_List.xlsx"); data _null_; file mymail to=('yourmail@email.com' ) cc=('myemail@email.com'); run; %end; %else %do; filename mymail email 'myemail@email.com' from='InternalReports <myemail@email.com>' subject='Test List'; data _null_; file mymail to=('myemail@email.com'); put "ERROR :("; run; %end;   Thanks a lot. ... View more