topic Re: last month before date of end of month in SAS Programming

last month before date of end of month

BrahmanandaRao — Fri, 21 Apr 2023 11:14:39 GMT

data n;
lastmonth_endof_before_date=intnx('day',(today()-1)-1,'e');
format lastmonth_endof_before_date    date9.;
run;

how to get last month before date of end of the month

ex: last month end is 31March2023 i am trying 30March2023 date

Re: last month before date of end of month

yabwon — Fri, 21 Apr 2023 11:18:46 GMT

data _null_;
lastmonth_endof_before_date=intnx('month',today(),0,'e')-1;
put lastmonth_endof_before_date date9.;
run;

Re: last month before date of end of month

PeterClemmensen — Fri, 21 Apr 2023 11:19:29 GMT

Add a -1 to your expression. SAS Dates are just integers 🙂

Re: last month before date of end of month

BrahmanandaRao — Fri, 21 Apr 2023 11:26:51 GMT

data n;
samedate=intnx('month',today(),0,'s');
prev_month=intnx('month',today(),-1,'s');
thismonth_begin=intnx('month',today(),0,'b');
nextmonth_begin=intnx('month',today(),1,'b');
prev_month_ending=intnx('month',today(),-1,'e');
next_month_ending=intnx('month',today(),1,'e');
last_2months=intnx('month',today(),-2);
lastmonth_endof_before_date=intnx('month',today(),-1,'e')-1;

format lastmonth_endof_before_date  last_2months next_month_ending samedate  thismonth_begin nextmonth_begin prev_month_ending prev_month:           date9.;
run;

lastmonth_endof_before_date=intnx('month',today(),-1,'e')-1;

Re: last month before date of end of month

yabwon — Fri, 21 Apr 2023 11:40:10 GMT

right 🙂 but you get the point 🙂