topic Re: Increment date automatically in New SAS User

Increment date automatically

Kirito1 — Mon, 26 Dec 2022 11:24:51 GMT

Suppose I have Date 25Dec2022 and I have declared it as date. Now I want it to increment the date every time I run it.

After running the code it should be 26Dec2022 and Again If we ran that code it should be 27Dec2022 and so on..

Can anyone suggest how should I proceed with it.

I think INTNX function would be useful but how would I automate this process After I have declared it once.

Re: Increment date automatically

PaigeMiller — Mon, 26 Dec 2022 11:49:12 GMT

You can increment dates by arithmetic. You want to simply add 1 to the date variable.

It is not clear if you want to do this in a data step or in a macro variable or somewhere else, so I offer no example of doing this. Please clarify.

Terminology : unlike other computer languages, in SAS you cannot "declare" anything. The variable either is a date variable or it is not a date variable.

Re: Increment date automatically

Kirito1 — Mon, 26 Dec 2022 11:43:56 GMT

How do I increment date by arithmetic can you provide any syntax for that. I want to apply this on a data step.

Re: Increment date automatically

PaigeMiller — Mon, 26 Dec 2022 11:51:55 GMT

You add 1 to the variable. I cannot provide example code because I asked you to clarify something, but you did not do so. I said: "It is not clear if you want to do this in a data step or in a macro variable or somewhere else, so I offer no example of doing this. Please clarify."

Re: Increment date automatically

Kirito1 — Mon, 26 Dec 2022 12:02:46 GMT

I want to do something like this but this is just normal a normal counting this code is doing. I am applying this code on a dataset I want it to update every time it reads the data.

For example:

DATA B; SET A (where=('DATE_OF_APPROVAL'N GE '01DEC2022'D));

I have hard coded the date here but if I run this data on 02Dec2022 I don't want to specify the Date everytime I run the code.

I somehow want to use the below code to update 'DATE_OF_APPROVAL' everytime I run this code.

%macro date_loop(start,end);
   %let start=%sysfunc(inputn(&start,anydtdte9.));
   %let end=%sysfunc(inputn(&end,anydtdte9.));
   %let dif=%sysfunc(intck(month,&start,&end));
     %do i=0 %to &dif;
      %let date=%sysfunc(intnx(month,&start,&i,b),date9.);
      %put &date;
     %end;
   %mend date_loop;

   %date_loop(25DEC2022,25DEC2023)

Is it clear now.

Re: Increment date automatically

PaigeMiller — Mon, 26 Dec 2022 12:10:22 GMT

@Kirito1 wrote:

I want to do something like this but this is just normal a normal counting this code is doing. I am applying this code on a dataset I want it to update every time it reads the data.

For example:
DATA B; SET A (where=('DATE_OF_APPROVAL'N GE '01DEC2022'D));
I have hard coded the date here but if I run this data on 02Dec2022 I don't want to specify the Date everytime I run the code.

I somehow want to use the below code to update 'DATE_OF_APPROVAL' everytime I run this code.

I think what you want is the TODAY() function. The is no incrementing here.

DATA B; 
SET A (where=(DATE_OF_APPROVAL GE today()));
run;