topic first date monday and last day friday in SAS Programming

first date monday and last day friday

mansour_ib_sas — Sat, 29 Feb 2020 11:51:12 GMT

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

Re: first date monday and last day friday

PaigeMiller — Sat, 29 Feb 2020 11:56:37 GMT

You haven't described the desired output.

Re: first date monday and last day friday

Ksharp — Sat, 29 Feb 2020 12:20:07 GMT

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;

Re: first date monday and last day friday

Reeza — Sat, 29 Feb 2020 19:35:31 GMT

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.