Forecasting using SAS Forecast Server, SAS/ETS, and more

Export results from SAS Forecast studio to create dashboard in Spotfire

Accepted Solution Solved
Reply
Contributor
Posts: 60
Accepted Solution

Export results from SAS Forecast studio to create dashboard in Spotfire

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


Accepted Solutions
Solution
‎04-27-2016 02:26 PM
SAS Employee
Posts: 4

Re: Export results from SAS Forecast studio to create dashboard in Spotfire

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

 

 

View solution in original post


All Replies
SAS Employee
Posts: 38

Re: Export results from SAS Forecast studio to create dashboard in Spotfire

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.

SAS Employee
Posts: 4

Re: Export results from SAS Forecast studio to create dashboard in Spotfire

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

 

 

Contributor
Posts: 60

Re: Export results from SAS Forecast studio to create dashboard in Spotfire

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?

 

Solution
‎04-27-2016 02:26 PM
SAS Employee
Posts: 4

Re: Export results from SAS Forecast studio to create dashboard in Spotfire

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

 

 

Contributor
Posts: 60

Re: Export results from SAS Forecast studio to create dashboard in Spotfire

oh thank you, that is exactly what i want to do.
SAS Employee
Posts: 38

Re: Export results from SAS Forecast studio to create dashboard in Spotfire

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 902 views
  • 1 like
  • 3 in conversation