Year Calculation

[Babloo]

I have the variables like Renewal_day and Renewal_month as follows and I want to calculate the Renewal_year. Variable

Renewal year can be calculated by using the variables Renewal_day and Renewal_month. If Renewal_day and Renewal_month values are past while comparing with today date value then Renewal_year should populate the value 2019 else it should be 2018.

Renewal_day	Renewal_month	Renewal_year
1	2	2019
8	4	2019
16	8	2018
4	11	2018
6	5	2019

Appreciate if someone of you guide me here.

[CalleJ]

Hello!

- This should cover your requirements. Set year to this year (year(today())).

- Add a year if month is past or month is this month but date is past.

data renewal_dates;
	renewal_day = 1;
	renewal_month = 2;
	output;
	renewal_day = 8;
	renewal_month = 4;
	output;
	renewal_day = 16;
	renewal_month = 8;
	output;
	renewal_day = 4;
	renewal_month = 11;
	output;
	renewal_day = 6;
	renewal_month = 5;
	output;
run;

data output;
	set renewal_dates;
	renewal_year = year(today());
	if renewal_month < month(today()) then renewal_year = renewal_year + 1;
	else if renewal_month = month(today()) and renewal_day < day(today()) then renewal_year = renewal_year + 1;
run;

Kind regards,

Calle

[ChrisNZ]

[Edited]

Something like this?

Renewal_year = year(today()) + ( mdy (Renewal_month, Renewal_day, year(today()) < today() );

[Kurt_Bremser]

year = year(today());
if mdy(month,day,year) < today() then year + 1;