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
The last parameter for your intnx should be same.
You also should use year and -1 interval.
Intns('yeat', today(), -1, 's')
Have you tried
test = intnx('year',today(),-1);
?
If yes, and it did not give you your wanted result, what was the difference?
The last parameter for your intnx should be same.
You also should use year and -1 interval.
Intns('yeat', today(), -1, 's')
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.