xxxxxxxxxx
data FirstLastMiddle;
date = '07DEC1941'd;
FirstDayPrevMonth = intnx('month', Date, -1, 'B'); /* B = beginning */
LastDayPrevMonth = intnx('month', Date, -1, 'E'); /* E = end */
MiddlePrevMonth = intnx('month', Date, -1, 'M'); /* M = middle */
FirstAnniv = intnx('year', Date, 1, 'S'); /* S = same */
format _ALL_ date9.;
run;
proc print data=FirstLastMiddle noobs;
run;
xxxxxxxxxx
data Months;
date = '07DEC1941'd;
FirstDayCurrMonth = intnx('month', Date, 0); /* 0 = current month */
FirstDayPrevMonth = intnx('month', Date, -1); /* -1 = previous month */
FirstDayNextMonth = intnx('month', Date, 1); /* 1 = next month */
FirstDay6Months = intnx('month', Date, 6); /* 6 = six months later */
format _ALL_ date9.;
run;
proc print data=Months noobs;
run;