topic Re: Grouping date variable into weeks in SAS Programming

Grouping date variable into weeks

Krysia24 — Wed, 30 Dec 2020 00:08:01 GMT

I have a date variable and I want to be able to calculate its corresponding week start date. Example:

Have:

Date

1/5/2020

1/6/2020

1/7/2020

1/12/2020

1/21/2020

1/23/2020

Want:

Date: Week Start Date:

1/5/2020 1/5/2020

1/6/2020 1/5/2020

1/7/2020 1/5/2020

1/13/2020 1/12/2020

1/21/2020 1/19/2020

1/23/2020 1/19/2020

Re: Grouping date variable into weeks

novinosrin — Wed, 30 Dec 2020 00:21:48 GMT




data have;
input date :mmddyy10.;
format date mmddyy10.;
cards;
1/5/2020

1/6/2020

1/7/2020

1/12/2020

1/21/2020

1/23/2020
;

data Want;
 set have;
 Week_start=intnx('Week',date,0,'b');
 format Week_start mmddyy10.;
run;

Re: Grouping date variable into weeks

Barkat — Tue, 27 Dec 2022 22:10:56 GMT

Here the week_start starts on Sunday. How can I modify the code, so the week_start starts on Saturday?

Re: Grouping date variable into weeks

Barkat — Tue, 27 Dec 2022 23:02:05 GMT

I found that.

data Want;
set have;
Week_start=intnx('Week.7',date,0,'b');
format Week_start mmddyy10.;
run;