Converting to month macro getting just January....

[CamannC]

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.

[allurai0412 · Accepted solution]

hi,

Delte extra ....'month' in the following  line and check/...

rolling_month=put((intnx("month", date_end, 1, "end")), $monname.);

This gives....rolling_month ........February...

Regards

ALLU

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((intnx("month", date_end, 1, "end")), $monname.);

rolling_month_end=put((intnx("month", date_end, -11, "sameday")), $yymmn6.);

format date date_end date9.;

run;

proc print data=date;

run;

[CamannC]

It worked!!  Thanks allurai!