topic Re: intnx start and end week name of month in SAS Programming

intnx start and end week name of month

Suryak — Tue, 28 Jun 2022 05:14:36 GMT

data Months;
do i ='01JAN2022'd to '31DEC2022'd;
FirstDayMonth = intnx('month', i,0,'b'); 
output;
do j= '01JAN2022'd to '31DEC2022'd;
EndDayMonth = intnx('month',j,0, 'e'); ; 
output;
drop firstdaycurrmonth enddaycurrmonth;
end;
end;
format _ALL_ weekdate9.;
run;
 
proc print data=Months noobs;
run;

Here i want start weekname and end weekname of each month in a given date range

Re: intnx start and end week name of month

Kurt_Bremser — Tue, 28 Jun 2022 05:32:54 GMT

Weeks have no names, only numbers. Or do you mean the weekday of a given date?

Re: intnx start and end week name of month

Suryak — Tue, 28 Jun 2022 05:36:37 GMT

i want to weekname start weekname and end weekname of each month
ex: This june month weekstarts wednesday endofmonth thursday

Re: intnx start and end week name of month

Kurt_Bremser — Tue, 28 Jun 2022 07:42:16 GMT

WEEKS DO NOT HAVE NAMES.

So the word "weekname" makes no sense.

Please show which value(s) you have, and what you want to get from it

Re: intnx start and end week name of month

BrunoMueller — Tue, 28 Jun 2022 07:59:58 GMT

Are you looking for something like this? The INTNX function can give you the first/last date of a given period.

data want;
  do month = 1 to 12;
    someDate = mdy(month, 15, 2022);
    startDay = intnx("month", someDate, 0, "B");
    endDay = intnx("month", someDate, 0, "E");
    output;
  end;

  format
    somedate date9.
    startDay endDay weekdate.
  ;
run;

proc print data=want noobs;
run;

Re: intnx start and end week name of month

Suryak — Tue, 28 Jun 2022 08:18:42 GMT

YES almost same result