DATE Calculation

[Bellefeuille]

Good Afternoon Guys,

Looking for some syntax help if you can 🙂

I need to create an effective date which is always to be Dec 31st of the following year

Example

If my Creation Date is 8/18/2017 my effective date would be DEC 31 2018

If my Creation Date is 12/31/2017 my effective date woul dbe DEC 31 2018

Ect.

Appreciate any assistance

[TomKari · Accepted solution]

The INTNX function is incredible. I suggest you read up about it.

data have;
	format CreationDate EffectiveDate date.;
	CreationDate = '1jan2017'd;
	EffectiveDate = intnx('year', CreationDate, 1, 'end');
	output;
	CreationDate = '18aug2017'd;
	EffectiveDate = intnx('year', CreationDate, 1, 'end');
	output;
	CreationDate = '31dec2017'd;
	EffectiveDate = intnx('year', CreationDate, 1, 'end');
	output;
run;

Tom