topic How to export table view on SAS Forecast Studio? in SAS Forecasting and Econometrics

How to export table view on SAS Forecast Studio?

br_aquino — Tue, 22 Jan 2019 15:29:09 GMT

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

Re: How to export table view on SAS Forecast Studio?

mitrov — Wed, 23 Jan 2019 00:39:50 GMT

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=p06h8cssnv1ukgn1tfx4cf2i0ih9.htm&locale=en

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

Michele

Re: How to export table view on SAS Forecast Studio?

br_aquino — Wed, 23 Jan 2019 16:48:11 GMT

Thank you Michele, that works.