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
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
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.