first date monday and last day friday

[mansour_ib_sas]

Hello,

I can't resolve this problem.

I try to have for each given date, Monday as the start of the week and Friday as the day of the weekend.

The error is made on the first day of the month.

The following example illustrates the error.

Thank you for your help.

data _null_;
   date = '03feb2020'd;
   firstday = intnx('week.2',date,-1);
   lastday  = intnx('week.6',date ,-1);
   put (date firstday lastday) (= date9.) ;
   
run;

Log

 73         data _null_;
 74            date = '03feb2020'd;
 75            firstday = intnx('week.2',date,-1);
 76            lastday  = intnx('week.6',date ,-1);
 77            put (date firstday lastday) (= date9.) ;
 78         
 79         run;
 
 date=03FEB2020 firstday=27JAN2020 lastday=24JAN2020

[PaigeMiller]

You haven't described the desired output.

[Ksharp]

As Paige said, post the output you want .

data _null_;
   date = '03feb2020'd;
   firstday = intnx('week.2',date,-1);
   lastday  = intnx('week.6',date ,0);
   put (date firstday lastday) (= date9.) ;
   
run;

[Reeza]

I think -1 is the issue. That moves it to the previous week, but if you want it within the same week that should be 0.