Date category that uses a 6 week interval

[Matthree]

I’m struggling a bit here and would greatly appreciate any advice.

I have a date category, we’ll call it “submitted_date”, that uses day intervals.

If I want I can make more categories based on “submitted_date” by right-clicking it and hitting “create date hierarachy”, then un-hiding the newly created categories for the hierarchy.

This will give me new categories based on “submitted_date” that use month, quarter and year intervals.

But what I want is a new category based on “submitted_date” that uses a 6 week interval.

I wish to be able to have, say, a line graph that uses “submitted_date” and be able to filter that data in that line graph to show the data for a 6 week period rather than a month, quarter or year.

I am using version 7.2

Any suggestions?

[SASKiwi]

First I think you need to decide how your "6-week interval" is defined. Do you want to align it with one of the week numbering standards of which there are at least 3 as defined here:

http://support.sas.com/documentation/cdl/en/lefunctionsref/67960/HTML/default/viewer.htm#n1ka2ulrvrj...

Or do you want it to align with calendar year, quarter, then 2 6-week intervals per quarter so you can construct a hierarchy?

It it is the latter then you won't be able you use SAS VA's automatic date hierarchies because they don't include 6-week intervals. Instead you will need to build separate year, quarter, and 6-week interval columns derived from your date column and then create a custom hierarchy based on the three columns.