sas first day of previous month
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;