Hi All,       I have a quick question. After the forecasting at forecast server, usually how will you deliver the forecast result to clients? Do they need to log to the forecast server to see the result?   Thank you! Jade ... View more

Hi All,     I have a quick question about writting SAS data back to Teradata.     1) If I use the TPT (Teradata Parallel Transporter) API to load data. LIBNAME TD TERADATA SERVER=*** DATABASE=***; Data TD.TEST(TPT=YES FASTLOAD=YES TPT_MAX_SESSIONS=4); set work.test123; Run; The process time is attached in Time1      2) If I use the normal SAS way to load data LIBNAME TD TERADATA SERVER=*** DATABASE=***; Data TD.TEST; set work.test123; Run; The process time is attached in Time2.   What puzzles me is why I need more time if loading data via 1), I thought it should be more efficient. Any comments, please!   Thank you! Jade ... View more

Hi All,       I have several questions about the space of work directory at SAS server:     1) how can I know the size of space in the work directory? Any SAS statements for this purpose?     2) How the space in the work directory is distributed between users at SAS server?     3)I f I know the size of the SAS table, how can I guess the work space that needed to process that SAS table?     Thank you!   Jade ... View more

Hi All,       I have difficulty to understand why the schema is case sensitive in libname statement when connecting to SQL tables with AD account.   For example:    LIBNAME test SQLSVR DATASRC='SQL_Server_name' qualifier=SQL_Database_name SCHEMA=dbo USER='domain\windows_ID' PASSWORD='windows_Password';   here the schema dbo is case sensitive, but the SQL server name and SQL database name are not case sensitive. Do you know the reason of that?   Thank you! Jade     ... View more

Hi All,        I am using SAS Forecast Studio on the server. I tried the Override calculator function, it is not available to me, is it normal? See the attached picture.        It is said "You cannot add overrides when the value for the Number of periods to forecast (horizon) option is less than the number of the Calculate statistics of fit over an out-of-sample range option" in the Forecast Studio User Guide, so maybe this reason caused the "override calculator" is not functional? Where can you get the the number of the calculated statistics of fit over an out-of-sample range? Thank you!   Jade ... View more