topic DATE Calculation in SAS Programming

DATE Calculation

Bellefeuille — Thu, 17 Aug 2017 18:32:59 GMT

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

Re: DATE Calculation

TomKari — Thu, 17 Aug 2017 18:44:05 GMT

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