Hi All,       I am new to SAS Forecast Studio. I found if I leave the project on for some time and click the models under Hierarchy view, I will get two messages and could not retrieve the forecast model. 1) Message 1: The selected series will be diagnosed in order to retrieve its model selection list. 2) Message 2: com.sas.analytics.forecasting.client.api.execeptions.InvalidForecastingSessionException: Session does not exist   Could you please let me know what's going on? My guess is I did not interact with the project for some time and could not activate the project any more.   Thank you! Jade ... View more

Hi All,       I used to run the stored SQL procedure via the following code, everything works:     PROC SQL; CONNECT TO SQLSVR (dsn="SQL_Database_name" uid="***" pwd="***") ; EXECUTE (HT.pLoadtest) by SQLSVR; Quit;       Recently the SAS admin re-defined the dsn on the SAS server, current dsn is defined at SQL server level, the previous dsn (that at SQL database level) does not exist any more.       I know we can add "Qualifier" in the Libname statement when the DATASRC is defined at SQL_Server level (See details below).   LIBNAME test SQLSVR DATASRC="SQL_Server_name" Qualifier=SQL_Database_name schema=HT user="***" password="***";      But I don't know what we should add the to PROC SQL pass throught process to get the stored SQL procedure (at HT schema)work. I tried the following coding and got an error, the error said "could not find stored procedureHT.ploadtest..... PROC SQL; CONNECT TO SQLSVR (dsn="SQL_Server_name" uid="***" pwd="***") ; EXECUTE (HT.pLoadtest) by SQLSVR; Quit;    Is there anything we can do to make the above coding work? Or the DSN has be be defined at the database level for the EXECUTE stored SQL procedure purpose?   Thank you so much!!! Thanks, Jade         ... View more

Hi all,      My quick question is what are the libraries when you at the step of "select the data set that you want to Forecast" in SAS Forecast Studio? The libraries I can see in Forecast studio are attached. BTW, I am using SAS Forecast Studio in SAS linux server.   1) I only can see the base SAS libraries such as Sashelp, Sasuser and work etc.  I could not load my forecast data to any of these libraries. 2) If you have extra libraries (compare to my attached list) that you can load your forecasting data to there, please let me know who have the right to set up that library and how to do that? Your help is appreciated! Really want to start to load my data and do forecasting!   Thanks, Jade ... View more

Hi All,       I am new to Forecast Studio, I wonder how could you import data to Forecast Studio?     If I can upload my data to library, it will solve my problem, But the libraries that are available to me only those default SAS libraries, and I could not upload data to any of those libraries. see attached for the libraries. BTW, I am using SAS server in Linux.     My questions:    Who can define a specified library for the forecast data set I will need, and how to define the library?     Thank you! Jade ... View more