About Mr_Sosa

Mr_Sosa · ‎05-06-2013

Udo, Thank you for the reply. I will take a look into this as a possible solution. I should have mentioned this in my earlier post, but I need to reconcile weekly and monthly FISCAL data. As I am sure you are aware, in the retail industry, we are using a fiscal calendar. So for instance, April 1st 2013 might actually fall in the fiscal month of March 2013 (the 5th week of the fiscal month of March to be exact). Would the method you recommended account for this, or would my BENCHID interval need to be something like R445MON rather than MONTH to account for this? Again, thank you for your input on this issue!

Mr_Sosa · ‎05-06-2013

All, I am currently trying to leverage PROC HPFTEMPRECON reconcile weekly forecasts to a monthly forecast. The literature I have read states that week to month reconciliation is not possible ( e.g., ID <variable> interval = week, BENCHID <variable> interval = month) due to the fact that weeks are not always nested within months. This is unlike reconciling quaters to the year (e.g., ID <variable> interval = QTR, BENCHID <variable> interval = YEAR) which is possible because quarters are fully nested in a year. I have tried to "force" the reconciliation by using an ID interval = WEEKV.7 and BENCHID interval = R445MON but the error states the following: ERROR: ID interval is not nested in BENCHID interval. Attempted use not currently supported. Does anyone know if there is a way to accomplish this task using HPFTEMPRECON? For instance, is it possible to create custom time intervals for the week and month that would reconcile to each other? Thank you for the help!

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: PROC HPFTEMPRECON -- week to month reconciliation?

PROC HPFTEMPRECON -- week to month reconciliation?

Re: PROC HPFTEMPRECON -- week to month reconciliation?

PROC HPFTEMPRECON -- week to month reconciliation?