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.
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;
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;
It worked!! Thanks allurai!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.