BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
br_aquino
Calcite | Level 5

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.

 table viewjpg.jpg

I'm in the version 14.3

 

Thank you,

 

Bruno Aquino

1 ACCEPTED SOLUTION

Accepted Solutions
mitrov
SAS Employee

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

 

View solution in original post

2 REPLIES 2
mitrov
SAS Employee

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
Calcite | Level 5

Thank you Michele, that works.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Multiple Linear Regression in SAS

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.

Discussion stats
  • 2 replies
  • 2172 views
  • 0 likes
  • 2 in conversation