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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.