topic Re: I need to create exact one year from today in SAS Programming

I need to create exact one year from today

ambadi007 — Thu, 12 May 2016 13:40:38 GMT

Hi Team,

I want to create an year value and it should be exact one year from today irrespective of leap year or what ever I have tried the below code

test=intnx('month',today(),-12,'B');

But it was not giving exact exact one year difference it was giving 01-May-2015 but i need 12-May-2015 ie if the job is running today it should calculate exact one year difference.

Thanks

Manesh

Re: I need to create exact one year from today

Kurt_Bremser — Thu, 12 May 2016 13:43:53 GMT

Have you tried

test = intnx('year',today(),-1);

If yes, and it did not give you your wanted result, what was the difference?

Re: I need to create exact one year from today

Reeza — Thu, 12 May 2016 13:57:25 GMT

The last parameter for your intnx should be same.

You also should use year and -1 interval.

Intns('yeat', today(), -1, 's')

Re: I need to create exact one year from today

Astounding — Thu, 12 May 2016 14:13:58 GMT

Also, you may want to compare these two to see if they give you the same results for leap years:

intnx('year', today(), -1, 'S')

intnx('month', today(), -12, 'S')

it's possible they are equivalent, but check for a Feb 28, Feb29, and March 1 date to see what you get.

***

I found time to test them ... they generate the same result.