Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Date category that uses a 6 week interval

Occasional Learner
Posts: 1

Date category that uses a 6 week interval

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?

Super User
Posts: 4,034

Re: Date category that uses a 6 week interval

[ Edited ]

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:




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.  

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation