topic Re: How to Calculate the year which is 20 years from run date. in New SAS User

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

annypanny — Mon, 11 May 2020 09:24:17 GMT

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;

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

Jagadishkatam — Mon, 11 May 2020 09:39:07 GMT

no need of do loop, please try the below code

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

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

ed_sas_member — Mon, 11 May 2020 09:44:06 GMT

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;

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

PaigeMiller — Mon, 11 May 2020 10:58:58 GMT

Another possibility

year_in_future = year(today())+20;

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

annypanny — Mon, 11 May 2020 11:18:03 GMT

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

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

annypanny — Mon, 11 May 2020 11:18:37 GMT

Hi thanks,
I have replied to another question.

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

annypanny — Mon, 11 May 2020 11:19:19 GMT

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