topic Re: SAS Date add 1 year in SAS Programming

SAS Date add 1 year

zimcom — Thu, 12 Mar 2020 19:42:22 GMT

Greetings!

What I have is a SAS data variable (e.g., 2015-03-07)

What I want is to add one year to the above variable (e.g., 2016-03-07)

When I used

DSDAT = intnx('year',DSDAT,1);

I got "2016-01-01", any idea why I did not get "2016-03-07"

Thanks

novinosrin — Thu, 12 Mar 2020 19:44:34 GMT

Try

DSDAT = intnx('year',DSDAT,1,'s');

's' stands for SAME meaning you are requesting to shift the default

zimcom — Thu, 12 Mar 2020 19:48:30 GMT

@novinosrin You are great help to me, thank you so much!