Can you export the results( forecasts and confidence intervals ) easy from SAS FS? Up to now i only saw the copy paste but its one by one and if you have a lot of models it doesnt make sense.
I have SAS Forecast Studio for desktop.
thanks
Actually, the naming convention is pretty consistent from project to project. Once you find the root path (e.g. C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects), you can assign the SAS libname in Base SAS or SAS EG or whatever SAS client you'd like to use for each level of the hierarhy and for each project. For example, I have the following two projects and their associated hierarchy,
Project1:regionName; productLine; productName
Project2: no hiearchy
libname p1l0 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1\hierarchy\top";
libname p1l1 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1\hierarchy\regionName";
libname p1l2 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1\hierarchy\productLine"
libname p1l3 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1\hierarchy\productName";
libname p2 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project2\hierarchy\leaf";
Hope these help answering your question.
Thanks,
Rain
All results are kept in SAS dataset in the project folders. The location of the project depends on you install but it is likely to be something like this C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1
In each level of the hierarchy you can find the data sets for that level. OUTFOR contains the model forecasts. RECFOR the reconciled forecasts and FINALFOR the final forecasts.
Hi
You can follow the steps below to find out the location of the output SAS tables:
1. Open the SAS Forecast Studio project
2. Select File - > Project Properties: the Location shows the path to the folder where the output SAS tables are stored
The OUTFOR table has the forecasts and the associated CI, while the FINALFOR table has the final forecasts and the associated CI (i.e. the results after reconciliation and manual overrides if there is any).
Thanks,
Rain
thank you i was able to find the sas tables. I have one additional question, so these tables are store as TMP.finalfor, so the way i went about it was open the table in sas base then create a library in SAS and store it there but i have to that for every hierarchy and then i have 4 different forecast projects so i have to do this 12 times. Is there a more efficient way to do this?
Actually, the naming convention is pretty consistent from project to project. Once you find the root path (e.g. C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects), you can assign the SAS libname in Base SAS or SAS EG or whatever SAS client you'd like to use for each level of the hierarhy and for each project. For example, I have the following two projects and their associated hierarchy,
Project1:regionName; productLine; productName
Project2: no hiearchy
libname p1l0 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1\hierarchy\top";
libname p1l1 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1\hierarchy\regionName";
libname p1l2 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1\hierarchy\productLine"
libname p1l3 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project1\hierarchy\productName";
libname p2 "C:\SAS\Forecast\Lev1\AppData\SASForecastServer14.1\Projects\Project2\hierarchy\leaf";
Hope these help answering your question.
Thanks,
Rain
If you look at the project root directory, there is a file called LIBRARIES_DECLARATION.SAS
All you need to do is to include that file into your sas program and it will create the libraries for you.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.