topic Re: Find data of the current days of week in New SAS User

current week

SASlearner97 — Fri, 11 Dec 2020 08:08:01 GMT

Re: Find data of the current days of week

PeterClemmensen — Thu, 26 Nov 2020 13:37:13 GMT

Do you only want monday to friday?

Shold we consider the case vairable?

Re: Find data of the current days of week

SASlearner97 — Thu, 26 Nov 2020 13:40:58 GMT

i want only monday to friday
the case variable is not important

thank you

Re: Find data of the current days of week

PeterClemmensen — Thu, 04 Mar 2021 11:04:49 GMT

Ok. See if the Intnx Function gives you what you want.

data have;
input title $ case sending_date :ddmmyy10.;
format sending_date ddmmyy10.;
datalines;
a 0 27-11-2020
b 0 27-11-2020
c 1 27-11-2020
d 1 02-12-2020
e 1 09-11-2020
f 1 10-11-2020
g 0 13-11-2020
;

data want(drop=case sending_date);
   set have;
   array d {5} Monday Tuesday Wednesday Thursday Friday;
   if intnx('week', today(), 0, 'b') <= sending_date <= intnx('week', today(), 0, 'e') then do;
      d[weekday(sending_date) - 1] = sending_date;
      output;
   end;
   format Monday Tuesday Wednesday Thursday Friday ddmmyy10.;
run;

Result:

Obs title Monday Tuesday Wednesday Thursday Friday 
1   a     .      .       .         .        27/11/2020 
2   b     .      .       .         .        27/11/2020 
3   c     .      .       .         .        27/11/2020

Re: Find data of the current days of week

SASlearner97 — Thu, 26 Nov 2020 14:00:29 GMT

Thank you so much! it works !

Re: Find data of the current days of week

PeterClemmensen — Thu, 26 Nov 2020 14:01:52 GMT

Anytime.