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#n1ka2ulrvrjlasn0z7beco2yrgas.htm   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.   ... View more