Computing Sequential Week Numbers Across Multiple Years

Posted by Brian Dates on
URL: http://spssx-discussion.165.s1.nabble.com/Computing-Sequential-Week-Numbers-Across-Multiple-Years-tp5740858.html

Cheers, everyone.

I have several million service times that I need to summarize by week, from a start date to end date over multiple years beginning with 10/01/2016 and ending 09/30/2021. I need to number the weeks sequentially over the five-year period rather than start over again with Week = 1 on every January 1. Can anyone point me in the direction of syntax that will accomplish this?

Thanks.

Brian