topic Re: How to create a dynamic macro variable which takes yesterday's date? in SAS Programming

How to create a dynamic macro variable which takes yesterday's date?

Shradha1 — Mon, 26 Apr 2021 06:17:43 GMT

I want to create a macro variable which takes the date of the day before, and hence, its value changes each day. I am using the following code:

call symputx('PREVIOUS_DATE' , put(intnx('day', today(), -1, 's'), date9.));

But the problem is that if yesterday was a Sunday, then I would require the macro to take the date of the day before yesterday. For example today id 26APR2021, and yesterday 25APR2021 was a sunday, so I want this macro to take value 24APR2021.

Is there a way to automate this using an if clause or anything else?

Re: How to create a dynamic macro variable which takes yesterday's date?

japelin — Mon, 26 Apr 2021 06:53:54 GMT

If you simply want to get the previous day if it is Sunday, you can use the WEEKDAY function.
If you need to take holidays into concern, please refer to the HOLIDAY function.(Only common holidays in the U.S. and Canada.)

data _null_;
  dt=intnx('day', today(), -1, 's');
  wk=weekday(dt);
  if wk=1 then dt=dt-1;
  call symputx('PREVIOUS_DATE' , put(dt, date9.));
run;

Re: How to create a dynamic macro variable which takes yesterday's date?

Patrick — Mon, 26 Apr 2021 07:13:46 GMT

Interval WEEKDAY<weekend days>W allows you to do this (with SAS the week starts Sunday so it's WEEKDAY17W). Documentation here.

data _null_;
  call symputx('dt',put(intnx('WEEKDAY17W',today(),-1),date9.));
  stop;
run;

%put &=dt;

Run above today on Monday April 26.

33         %put &=dt;
DT=23APR2021