topic Re: find first day of current month,prev month,next month in New SAS User

find first day of current month,prev month,next month

animesh123 — Thu, 01 Dec 2022 18:53:02 GMT

I want to find First day of current month, Previous month , Next month as the below code is getting an error

Data test;

date="02DEC2022"d;

Frstday=Intnx("date",date,0);

run;

Re: find first day of current month,prev month,next month

PaigeMiller — Thu, 01 Dec 2022 18:57:27 GMT

There is no "Date" value for the first argument to INTNX. You want to use the "Month" argument here.

Frstday=Intnx("month",date,0,'b');

Re: find first day of current month,prev month,next month

Kurt_Bremser — Thu, 01 Dec 2022 18:56:54 GMT

In the INTNX Function , use an interval of "month" and the additional modifier "b" (for begin).

Re: find first day of current month,prev month,next month

PeterClemmensen — Thu, 01 Dec 2022 18:57:16 GMT

Try this

data test;
   date="02DEC2022"d;

   prevmonth = intnx('month', date, -1, 'b');
   thismonth = intnx('month', date,  0, 'b');
   nextmonth = intnx('month', date,  1, 'b');

   format prevmonth thismonth nextmonth ddmmyy10.;
run;

Re: find first day of current month,prev month,next month

ballardw — Thu, 01 Dec 2022 19:06:35 GMT

The basis indicators 'B' (begin), 'E' (end), 'S' (same) are helpful

Data test;
  date="02DEC2022"d;
  Frstdaycurrentmonth=Intnx("month",date,0,'B');
  FrstdayPrevMonth=Intnx("month",date,-1,'B');
  FrstdayNextmonth=Intnx("month",date,1,'B');
  FrstdayThisYear = intnx('year',date,0,'B');
  LastdayThisYear = intnx('year',date,0,'E');
  FrstdayLastYear = intnx('year',date,-1,'B');
  LastdayLastYear = intnx('year',date,-1,'E');
  FrstdayNextYear = intnx('year',date,1,'B');
  LastdayNextYear = intnx('year',date,1,'E');

  SamedayPrevMonth=Intnx("month",date,-1,'S');
  SamedayNextmonth=Intnx("month",date,1,'S');
  SamedayPrevYear=Intnx("year",date,-1,'S');
  SamedayNextYear=Intnx("year",date,1,'S');

  format date frstday: lastday: Sameday: date9.;
 
run;