I'm fitting batch forecasts in Forecast Studio. For example:
Fiscal Yr | YearMo | Total | Series 1 | Series 2 | Series 3 | Series 4 |
2006 | 200510 | 26338 | 16979 | 5293 | 10509 | 1177 |
2006 | 200511 | 24133 | 15026 | 4211 | 9708 | 1107 |
2006 | 200512 | 27442 | 16378 | 5184 | 10068 | 1126 |
2006 | 200601 | 25831 | 15533 | 4351 | 10104 | 1078 |
2006 | 200602 | 26873 | 15395 | 2954 | 11257 | 1184 |
2006 | 200603 | 32136 | 19377 | 4093 | 13789 | 1495 |
2006 | 200604 | 58889 | 49849 | 36822 | 11929 | 1098 |
2006 | 200605 | 72679 | 62809 | 48554 | 13008 | 1247 |
2006 | 200606 | 37749 | 27585 | 12171 | 14169 | 1245 |
2006 | 200607 | 32967 | 24055 | 10258 | 12543 | 1254 |
2006 | 200608 | 30900 | 19856 | 3972 | 14202 | 1682 |
2006 | 200609 | 27756 | 17866 | 3026 | 13350 | 1490 |
2007 | 200610 | 27915 | 18024 | 2987 | 13440 | 1597 |
2007 | 200611 | 24968 | 15801 | 2646 | 11784 | 1371 |
2007 | 200612 | 25051 | 15096 | 2575 | 11289 | 1232 |
2007 | 200701 | 27525 | 15833 | 2405 | 12142 | 1286 |
2007 | 200702 | 27436 | 15634 | 2641 | 11788 | 1205 |
2007 | 200703 | 30060 | 17432 | 3515 | 12712 | 1205 |
2007 | 200704 | 125015 | 113958 | 98665 | 13978 | 1315 |
2007 | 200705 | 33470 | 22134 | 5020 | 15486 | 1628 |
2007 | 200706 | 32546 | 21665 | 4678 | 15077 | 1910 |
2007 | 200707 | 34519 | 22897 | 4887 | 16224 | 1786 |
2007 | 200708 | 26916 | 16899 | 3603 | 11938 | 1358 |
2007 | 200709 | 27510 | 17369 | 2900 | 12901 | 1568 |
Without editing out dates prior to import, is it possible to adjust individual time series so that some forecasts begin on different dates than other time series in the same batch? For example, Series 1 and 2 Begin on 200610, while all other series begin on 200510?
Thanks!
I am not sure I fully understand your question. Do you want to set the forecasts to missing values for some dates?
If so, it would have to be done outside Forecast Studio. Forecast Studio generates a forecast for the first date for which it is feasible. You can create a stored process to do that and then run it within Forecast Studio. But that would still require manual coding.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.