Sort Data by Week Number

Posted on April 16, 2014

Sort Data by Week Number

There are times when doing reports when you need to sort your values into weeks.
Most people would end up writing a program to do this, but that is not necessary.

So assuming attribute 14 contains a date, then

F Correlative
F;14;C7;/
A Correlative
A;(14 / “7”)

A full dictionary item would like the like the following
WEEK.NBR
001 S
002 0
003 Week Number
008 F;14;C1;+;C7;/
009 R
010 6

WEEK.NBR is now the week number since 1968, with Sunday as the start of the week. You can then
use this in a BREAK-ON.

SORT FILE BY DATE BREAK-ON WEEK.NBR

If you want to have Monday as the beginning of the week, then do the follow:

WEEK.NBR.M-S
001 S
002 0
003 Week Number
008 F;14;C1;-;C7;/
009 R
010 6

If you want to sort based on the week number within the year, use:

WEEK.NBR.IN-YR
001 S
002 0
003 Week Number
008 A;(14 / “7”)-((“01/01/”:(14(DY)))(DI) / ”7”)
009 R
010 6

Credit to Tom Phillips.

Tags: ,

Categories: DICT Tips


Comments are closed