Hi, I also have the same requirement as you. I also confirmed with SAS Support (Thailand) that there is no way to override a system date. The best way is to declare macro variable to handle the execution date. Here is example. Before t1.SALES_DATE >= INPUT(PUT(Intnx('Month', TODAY()-1 ,- 0, 'B'), YYMMDDN8.), 8.) After %let _Current_Date_= 01MAY2023;/*for normal case : set value=%sysfunc(today(), date9.); , for rerun: set value as a specific date*/ %put Current_Date=&_Current_Date_.; t1.SALES_DATE BETWEEN INPUT(PUT(Intnx('Month', "&_Current_Date_."d -1 ,- 0, 'B'), YYMMDDN8.), 8.) AND INPUT(PUT(Intnx('Month', "&_Current_Date_."d -1 ,- 0, 'E'), YYMMDDN8.), 8.)
... View more