Hi All,      I guess the TPT is not set up correctly on the System.    I am using SAS server on Linux. I can use TPT to transfer data from SAS to Teradata table in SAS EG. The coding is as below:       Data TDLib.SAS_To_TD (tpt=yes fastload=yes tpt_max_sessions=4 ); set sashelp.shoes (obs=5); Run;     But when I transfer data from Teradata to SAS table in SAS EG using the coding below, I got a note (in the EG log file) said that the TPT was not used .      Data work.TD_To_SAS ; Set TDlib.visits_table (tpt=yes fastexport=yes tpt_max_sessions=4); Run;    /*NOTE: Teradata connection: TPT (the default) was NOT used, the FastExport utility was used instead.*/        Do you have any idea what software is missing on the SAS server side or Teradata server side? Thank you!   Jade ... View more

Hi All,       I'm forecasting next week visit (11/21/2017-11/27/2017) based on the visit history data I have, and I am considering holidays (1 is holiday and 0 is not) in the forecasting.     I have several questions of the Aggregation and Accumulation:     1) What's the difference between Aggregation and Accumulation in the Forecasting?     2) In my example below, the hierarchy is Total----Location---Department.      For the dependent variables "Visits" I think I will choose "Sum of Values" for Aggregation and Accumulation      But I am not sure about the independent variable "Holidays", what should I choose for Aggregation and Accumulation of variable "Holidays" ? Maybe choose "Average of Values"  (See details in attachments)? Any comments are welcome!   The data structure I have is below:     Date Location department Visits Holidays 1/1/2010 A child 30 1 1/1/2010 A Adult 50 1 1/1/2010 B child 20 1 1/1/2010 B Adult 30 1 1/2/2010 A child 200 0 1/2/2010 A Adult 300 0 1/2/2010 B child 200 0 1/2/2010 B Adult 350 0 1/3/2010 A child 100 0 1/3/2010 A Adult 300 0 1/3/2010 B child 100 0 1/3/2010 B Adult 350 0 Values going on Values going on Values going on Values going on Values going on 11/20/2017 A child 100 0 11/20/2017 A Adult 200 0 11/20/2017 B child 100 0 11/20/2017 B Adult 250 0 11/21/2017 A child . 0 11/21/2017 A Adult . 0 11/21/2017 B child . 0 11/21/2017 B Adult . 0 11/22/2017 A child . 0 11/22/2017 A Adult . 0 11/22/2017 B child . 0 11/22/2017 B Adult . 0 11/23/2017 A child . 1 11/23/2017 A Adult . 1 11/23/2017 B child . 1 11/23/2017 B Adult . 1 11/24/2017 A child . 0 11/24/2017 A Adult . 0 11/24/2017 B child . 0 11/24/2017 B Adult . 0 11/25/2017 A child . 0 11/25/2017 A Adult . 0 11/25/2017 B child . 0 11/25/2017 B Adult . 0 11/26/2017 A child . 0 11/26/2017 A Adult . 0 11/26/2017 B child . 0 11/26/2017 B Adult . 0 11/27/2017 A child . 0 11/27/2017 A Adult . 0 11/27/2017 B child . 0 11/27/2017 B Adult . 0      Thanks, Jade ... View more