topic Re: How to create a macro variable which takes date values based on today's date? in SAS Programming

How to create a macro variable which takes date values based on today's date?

Shradha1 — Sat, 24 Apr 2021 10:00:55 GMT

I want to create two macro variables, one for start date and one for end date, both in date9. format. the start date will be 60 days before today's date and end date will be 7 days before today's date. Suppose, today is 30APR2021, then I can create macros like this:

%let start_date= 01MAR2021;

%let end_date= 23APR2021;

But the problem with this is that I have to run this code on a daily basis which means that each day I will have to change the values of the macro variables. So I want to automatize it in a way that if I am running the code on 01MAY2021 (T) suppose, then the macros will automatically take Start date= 02MAR2021 (T-60) and End date = 24APR2021 (T-7).

Is there any way to automatize these macros to become dynamic and to take values based on the current date?

Re: How to create a macro variable which takes date values based on today's date?

PeterClemmensen — Sat, 24 Apr 2021 10:11:16 GMT

Try this

data _null_;
   call symputx('start_date', put(intnx('day', "30APR2021"d, -60, 's'), date9.));
   call symputx('end_date'  , put(intnx('day', "30APR2021"d, -7, 's'), date9.));
run;

%put &start_date.;
%put &end_date.;

Re: How to create a macro variable which takes date values based on today's date?

PeterClemmensen — Sat, 24 Apr 2021 10:11:56 GMT

Simply replace "30APR2021"d with today() for the dynamic transformation.