Hi SAS VA Experts,
I'm working with time series data in SAS VA and need some guidance on how to best display a full-year forecast.
My Data:
I have a dataset with a 'Year-Month' variable (e.g., "2024-01") and a corresponding 'Count' for each month. This data spans multiple previous years, and I have actual data for the current year up to a certain point.
Data Excerpt:
Year-Month Count
| 2024-01 | 15877 |
| ... | ... |
| 2024-12 | 10630 |
| 2025-01 | 16409 |
| 2025-02 | 13719 |
| 2025-03 | 15951 |
| 2025-04 | 14656 |
| (Data for May 2025 onwards would be future/forecasted values) | |
The Goal:
I want to display the total 'Count' for the full year 2025. This total should combine:
- Actual 'Count' values for the months in 2025 that have already occurred.
- Forecasted 'Count' values for the remaining future months of 2025.
Current Approach & Challenge:
SAS VAs built-in forecasting objects are great for generating month-by-month predictions. I can visually see these predictions on a time series plot. To get the annual total for 2025, I can manually sum the actual monthly values for 2025 with the predicted monthly values from the forecast plot.
However, this manual summation isn't practical for my report users. They need to see the total 2025 forecast (actual + predicted sum) directly within a table or, ideally, visualized in a plot.
Question:
Is it possible in SAS VA to automatically calculate and display this combined actual and forecasted annual total? If so, could you provide a hint or point me in the right direction? I'm looking for a way to present this aggregated yearly forecast figure to my users without requiring manual calculations on their part.
Any assistance would be greatly appreciated
I use SAS VA version: 8.5.2,
SAS Viya version: V.03.05
