topic Re: Re:thank you for quick response,but the days will repeat in this case how i need get the weeks in SAS Programming

Continous weeks calculation

Ganasingh — Fri, 09 Feb 2024 09:28:16 GMT

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
.
.
.

Re: Hello everyone,kindly Help me on below request

Kurt_Bremser — Wed, 07 Feb 2024 19:20:46 GMT

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

Re:thank you for quick response,but the days will repeat in this case how i need get the weeks

Ganasingh — Thu, 08 Feb 2024 05:02:24 GMT

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

01/01/2024. 5

08/01/2024. 6

25/12/2023. 4

Re: Re:thank you for quick response,but the days will repeat in this case how i need get the weeks

Kurt_Bremser — Thu, 08 Feb 2024 08:31:57 GMT

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

Re: Re:thank you for quick response,but the days will repeat in this case how i need get the weeks

Ganasingh — Thu, 08 Feb 2024 14:26:25 GMT

Yes, but week will be 1 for earliest date.

Re: Re:thank you for quick response,but the days will repeat in this case how i need get the weeks

Kurt_Bremser — Thu, 08 Feb 2024 15:36:39 GMT

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