topic grouping the date variable on weekly basis in New SAS User

grouping the date variable on weekly basis

Pooja98 — Mon, 25 Oct 2021 16:39:54 GMT

Hi all,

i got some data on daily basis, but i want to convert it into weekly basis

i need it like on Saturday -Friday basis

For example,

1. 09-06-21

2. 14-06-21

3. 05-06-21

4. 11-06-21

5. 28-06-21

6. 25-06-21

7. 04-06-21

where No.7 lies in one week, whereas No.1,3,4 lies in another week.

my data contains record from 2019, but i need it on weekly basis.

It will be helpful if its available in both SAS and excel solution.

Thanks In Advance

Re: grouping the date variable on weekly basis

ballardw — Mon, 25 Oct 2021 16:52:38 GMT

I am not sure what your desired output would look like. You need to provide an example of the expected output.

First question, are your "dates" actually SAS date values? Show us the variable type and format from Proc Contents for your variable.

Re: grouping the date variable on weekly basis

Ksharp — Tue, 26 Oct 2021 12:27:36 GMT

Check function WEEK() .

Re: grouping the date variable on weekly basis

Kurt_Bremser — Tue, 26 Oct 2021 12:59:00 GMT

SAS procedures (except SQL) that do summarizing will honor formatted values of class/group variables, so there you only need to use a week-based format.