How to Calculate the year which is 20 years from run date.

[annypanny]

How to Calculate the year which is 20 years from run date. E.g if today’s date is 11MAY2020, then this step will give year 2040.

I have used the below code but didn't find the solution.

data want;
set have;
do n=1 to 20 by +1;
date=intnx('year', &rundate, +n);
format date ddmmyyn8.;
output;
end;
run;

[Jagadishkatam · Accepted solution]

no need of do loop, please try the below code

data want;
date=intnx('year', today(), +20,'SAME');
format date ddmmyyn8.;
run;

[annypanny]

Hi thanks, please help me in another question linked with this
https://communities.sas.com/t5/SAS-Programming/How-to-Calculate-this-steps/td-p/646588

[ed_sas_member]

HI @annypanny 

You can retrieve the year which is 20 years from run date by using the INTNX function.

The modifier "S" tells SAS to pick the same date (-> so 11MAY2040).

For your other questions, could you please explain where do we find the collection name? For example, is Flexi 2040-42 (BLK) the name of the production dataset?

Best,

data have;
	format today_date date9.;
	today_date = today();
	year20 = year(intnx('year',today_date,20,"s"));
run;

[annypanny]

Hi thanks,
I have replied to another question.

[PaigeMiller]

Another possibility

year_in_future = year(today())+20;

[annypanny]

thanks, it is solved. Can you help me in another question linked with this question.
https://communities.sas.com/t5/SAS-Programming/How-to-Calculate-this-steps/td-p/646588