@Danchek7
Making A LOT of assumptions what you're asking for below code could be an option.
data have;
input DATE :date9. YEARS_TO_END MONTHS_TO_END;
format date date9.;
datalines;
31MAR2016 03 3
;
run;
data want;
set have;
format end_date date9.;
end_date=intnx('month',date,12*years_to_end+months_to_end,'e');
run;
In EG you'd create a calculated column in a Query via a formula like:
intnx('month',date,12*years_to_end+months_to_end,'e')
... View more
