Continous weeks calculation

[Ganasingh]

1.I need code to calculate continuous weeks if year changes also weeks needs to be continue like below.
2.week should begin with 1

Date. Week
04/12/2023. 1
11/12/2023. 2
18/12/2023. 3
25/12/2023. 4
01/01/2024. 5
08/01/2024. 6
.
.
.

[Kurt_Bremser]

data want;
date = "04dec2023"d;
do week = 1 to 6;
  output;
  date + 7;
end;
format date ddmmyys10.;
run;

[Ganasingh]

T

Date. Week

04/12/2023. 1

04/12/2023 1

11/12/2023. 2

18/12/2023.3

04/12/2023. 1

25/12/2023. 4

25/12/2023. 4

01/01/2024. 5

08/01/2024. 6

25/12/2023. 4

[Kurt_Bremser]

Does that mean you already have the dates in a dataset, and want to calculate the week numbers based on the earliest found date?

[Ganasingh]

Yes, but week will be 1 for earliest date.

[Kurt_Bremser · Accepted solution]

data want;
set have;
retain begin;
if _n_ = 1 then begin = date;
week = intck('week`,begin,date) + 1;
drop begin;
run;