As long as you use actual date values you should have no need to involve macros for most things. And the macro language has no actual native date manipulation so you would be calling data step functions anyway.   The function today() should return the day  a program runs. You can test the data of the week with the WEEKDAY function with a date value. Weekday( today() ) returns 1 for Sunday, 2 for Monday … 7 for Saturday. So: If weekday(today()) = 2 then do;     <Monday code> end; else if weekday(today()) = 6 then do;    <Friday code> end;   The function INTNX can be used to set a date based on an existing date and an interval. otherdate = intnx('day', today(), 2) ; for example would set a value of 2 days from today for the SAS date value corresponding to 11Aug2018 when run on 09Aug2018.   Your code sort of implies that you may be entering values such as 20180809 manually. Those are NOT date values as far as SAS is concerned. A literal date value would be entered in SAS using '09AUG2018'd. If you are comparing the results of the TODAY() function to variables that look like 20180809 then some work will need to be done. You would have to tell us whether your dates are numeric or character and if they always appear as that OR if they actually are SAS date valued variables and have a YYMMDDN8. format applied. ... View more