The dataset I am dealing here is Price Commodity relationship and it has values like:
I built several models using Proc Varmax and Proc UCM and I have the Fit Statistics and Parameter Estimates for these models. My requirement is to forecast the amount sold for different scenarios of Avg_Price_Diff to check how the forecast will change if we change the Avg_Price_Diff using these two models.
Is there a way to score data for these different price difference scenarios using the models built by Proc UCM and Proc Varmax.
Please let me know in case you need any further information. Thanks a lot in advance!
If you have access to SAS Forecast Server you will be able to take advantage of Forecasting Model Score Files and DATA Step Functions at least for your UCMs. See Chapter 22 of the SAS Forecast Server Procedures User's Guide. Or you could use SAS Forecast Studio's scenario analysis feature which provides access to this functionality.
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.