How to export table view on SAS Forecast Studio?

[br_aquino]

Hello, first post here.

I'm working with SAS Forcast Studio, it is a very nice tool and made very good predictions.

Now I'm trying to export the results to calculate the MAPE in other way.

Can someone help me to export the window Table View from SAS Forecast Studio, or some other way to export this data to csv, excel, or any other way?

I have attached a image of the window I'm traing to export.

 

I'm in the version 14.3

Thank you,

Bruno Aquino

[mitrov · Accepted solution]

Hi Bruno,

All outputs of Forecast Server are contained in SAS data sets. The data sets are located in subfolders inside the project folder. The structure of the folder reflects the hierarchical structure of the project. This note should help you locate the location of the projects:

http://support.sas.com/kb/56/569.html

By default, the location for creating new projects in SAS Forecast Studio is
C:\SAS\ForecastStudio for Windows and {homedir}/sas/ForecastStudio for Unix.

The data sets are described in the appendix of the user guide. I hope the following links works. It should take you to that. 

https://go.documentation.sas.com/?cdcId=fscdc&cdcVersion=14.3&docsetId=fsug&docsetTarget=p06h8cssnv1...

For the table with the statistics of fit in your screenshot you need the OUTSTAT and RECSTAT data sets. 

Michele

[br_aquino]

Thank you Michele, that works.