topic Re: Converting to month macro getting just January.... in SAS Programming

Converting to month macro getting just January....

CamannC — Wed, 20 Mar 2013 12:12:56 GMT

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.

Re: Converting to month macro getting just January....

allurai0412 — Wed, 20 Mar 2013 12:43:05 GMT

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;

Re: Converting to month macro getting just January....

CamannC — Wed, 20 Mar 2013 15:48:19 GMT

It worked!! Thanks allurai!