I have daily data for 2 years starting from jan1 2014 till december 31 2015. I want to forecast for next 365 days using this data set. I am using below code.

PROC UCM data=Mydata;                                                                                                                                                                                                                                      
id date interval=day; /*set the interval as day*/                                                                                                                                                                                                                                          
model Sold;
slope ;                                                                                                                                                                                                                                                         
cycle period=365.24 rho=1 variance=0 noest=(rho period variance);                                                                                                                                                                                               
forecast lead=365 OUTFOR=Ucmm.DATA;                                                                                                                                                                                                                             

There is a trend based on day of the week and month of the year. How do I specify that? I understand for day of week it can be set as 7. For month how can I specify that, as some months have 31 days while some others have 30 and yet february has 28/29 days. How do I solve this? I know it can be specified using season; command. But how?

Also, how to include impact of certain occasions like Christmas, new year, Thanksgiving etc? I believe model; command takes care of that as per this paper. How many of these dummy variables can we include? Is there any limit?


closed as off-topic by kjetil b halvorsen, Michael Chernick, mkt, jpmuc, Peter Flom Jul 28 at 12:24

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question appears to be off-topic because EITHER it is not about statistics, machine learning, data analysis, data mining, or data visualization, OR it focuses on programming, debugging, or performing routine operations within a statistical computing platform. If the latter, you could try the support links we maintain." – kjetil b halvorsen, Michael Chernick, mkt, jpmuc, Peter Flom
If this question can be reworded to fit the rules in the help center, please edit the question.

  • $\begingroup$ You might also ask about Holiday effects , changes in daily patterns over time or the effect of certain days in the month which is quite common with daily data . $\endgroup$ – IrishStat Jan 3 '16 at 12:23
  • $\begingroup$ Thanks for pointing out, i believe command model; takes care of that. I will add it to validate though. $\endgroup$ – Enthusiast Jan 3 '16 at 12:25
  • $\begingroup$ You might share your data, your results , including the final error process often laden/bloated with unidentified structure due to deficient exploratory analysis and ask the list for some comparative/more comprehensive existing approaches. $\endgroup$ – IrishStat Jan 3 '16 at 12:34
  • $\begingroup$ Can you elaborate on exploratory analysis part please? For daily data, i plotted pattern by day of week, week of the year, day of month, month of the year. What more should i do in this phase? am i missing anything that i should be doing? $\endgroup$ – Enthusiast Jan 3 '16 at 12:48
  • $\begingroup$ For example the daily pattern for a Monday might be +20 based upon 700 observations ( really 100 samples for Monday). Now the Monday (statistically significant) pattern might be +10 for the first 50 and +30 for the last 50 , averaging 20 overall Going forward it might be silly to use +20 rather than the more correct +30 as the offset for Monday. You are trying to do visual analysis by plotting the data rather than statistical analysis to gleen the underlying significant patterns . It ight be time to move on and to rest your weary eyes . $\endgroup$ – IrishStat Jan 3 '16 at 14:51