topic Create macro var Today minus 1 or Today minus 2 in SAS Programming

Create macro var Today minus 1 or Today minus 2

Ronein — Mon, 29 Jan 2024 13:53:15 GMT

Hello

I want to create a macro variable that calculate YYYY-MM-DD value by the following rule:

If today is Sunday-Friday then

%let YYYYMMDD =%sysfunc(putn(%sysevalf(%sysfunc(today())-1), YYMMDD10.));

If today is Saturday then
%let YYYYMMDD =%sysfunc(putn(%sysevalf(%sysfunc(today())-2), YYMMDD10.));

What is the way to do it please?

Re: Create macro var Today minus 1 or Today minus 2

LinusH — Mon, 29 Jan 2024 14:30:28 GMT

You can use the weekday() function together with %IF logic.

Re: Create macro var Today minus 1 or Today minus 2

yabwon — Mon, 29 Jan 2024 14:54:40 GMT

Try this:

%let yyyymmdd = %sysfunc(int(%sysevalf(%sysfunc(today())-1-(%sysfunc(weekday(%sysfunc(today())))=1))),yymmdd10.);

%put &=yyyymmdd.;

Bart

Re: Create macro var Today minus 1 or Today minus 2

yabwon — Mon, 29 Jan 2024 14:59:08 GMT

Or with FCMP, which is easier to read and modify:

proc FCMP outlib=work.f.p;
  function fff();
    return( today()-1-(weekday(today())=1) );
  endsub;
run;
options append=(cmplib=work.f);

%let yyyymmdd=%sysfunc(fff(),yymmdd10.);
%put &=yyyymmdd.;

Bart

Re: Create macro var Today minus 1 or Today minus 2

ballardw — Mon, 29 Jan 2024 16:15:22 GMT

Generic style comment: If the macro variable is to ever be used in comparisons with date values or calculations then do not format it.

The time to use formatted macro date values is for text that humans read such as title statements or possibly filenames.