Hi, I'm not sure why this is not giving me the right date. I'm trying to create a macro from to pull 'February' as the "rolling_month", but "rolling_month" comes out at January (even when I change the -11 to something else, like 13 or 5. data date; date="1FEB2013"d; *This is the date of run (regarding data up until month before date of run); date_end=intnx("month", date, -1, "end"); rolling_month=put((month(intnx("month", date_end, -11, "begin"))), $monname.); rolling_month_end=put((intnx("month", date_end, -11, "sameday")), $yymmn6.); format date date_end date9.; run; proc print data=date; run; Any help would be appreciated!! Thanks in advance.
... View more