topic Re: Taking Dates Dynamically in SAS Programming

Taking Dates Dynamically

Son_Of_Krypton — Thu, 08 Oct 2020 07:56:03 GMT

Currently i am fetching data based on below date filter manually.

Previous_Date>20191201 and Current_Date<20201201

I want take above date dynamically using macro.

Then next year it should be Previous_Date>20201201 and Current_Date<20211201 and it should go on for every year

Re: Taking Dates Dynamically

Kurt_Bremser — Thu, 08 Oct 2020 08:08:42 GMT

I SERIOUSLY doubt that your code works, unless you have "dates" stored in a most unusable fashion. December 1st, 2019 must be written as "01dec2019"d to be a SAS date value.

Having said that, here's code that shows how to derive your dates from a given year:

%let year=2020;

data _null_;
call symputx("prevcut",mdy(12,1,&year. - 1));
call symputx("currcut",mdy(12,1,&year.));
run;

which you can then use to compare with dates stored in a dataset:

Previous_Date > &prevcut. and Current_Date < &currcut.

Re: Taking Dates Dynamically

Son_Of_Krypton — Thu, 08 Oct 2020 09:22:32 GMT

I don't want to use %let statement it should pick up the year from dataset and should increase by year when it will start running for next year

Re: Taking Dates Dynamically

Kurt_Bremser — Thu, 08 Oct 2020 09:44:03 GMT

@Son_Of_Krypton wrote:
I don't want to use %let statement it should pick up the year from dataset and should increase by year when it will start running for next year

Is the year in a variable within the dataset, or is it part of the dataset name? If the latter, are those dataset names structured consistently, and how?