1          %studio_hide_wrapper;
82         proc sort data=ctg.nestle_promos out=ctg.nestle_promos_sorted;
83           by province_name type brand Date;
84         run;
NOTE: There were 23847 observations read from the data set CTG.NESTLE_PROMOS.
NOTE: The data set CTG.NESTLE_PROMOS_SORTED has 23847 observations and 36 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.04 seconds
      
85         
86         proc hpfengine data = ctg.nestle_promos_sorted outfor=forecasts;
87         id date interval=month accumulate=total notsorted;
88          by province_name type brand;
89         forecast Net_Revenue;
90         run;
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=Manitoba Type=INSTANT Brand=NESTLE
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=New Brunswick Type=CHOCOLATE Brand=BIG TURK
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=Newfoundland and Labrador Type=HEALTHCARE Brand=GARDEN OF LIFE
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=Nova Scotia Type=BEVERAGES Brand=CARO
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=Nova Scotia Type=CHOCOLATE Brand=TURTLES
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=Nova Scotia Type=HEALTHCARE Brand=BOOST
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=Nova Scotia Type=HEALTHCARE Brand=GARDEN OF LIFE
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=Nova Scotia Type=WATER Brand=MONTCLAIR
WARNING: There is only 1 usable input observation. (Some observations may have been ignored because of previous errors.)
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to select again after disabling 
         selection list seasonal and transformation diagnostics.
WARNING: No model was chosen from the selection list for variable Net_Revenue. Now attempting to forecast using exponential 
         smoothing.
WARNING: Unable to forecast the variable Net_Revenue. Forecast values set to missing.
NOTE: The above message was for the following BY group:
      Province_Name=Saskatchewan Type=INSTANT Brand=GERBER
NOTE: Number of series processed: 128
NOTE: Number of forecasts requested: 128
NOTE: Number of forecasts failed: 9
NOTE: There were 23847 observations read from the data set CTG.NESTLE_PROMOS_SORTED.
NOTE: The data set WORK.FORECASTS has 4609 observations and 11 variables.
NOTE: The data set WORK.DATA2 has 4609 observations and 5 variables.
NOTE: PROCEDURE HPFENGINE used (Total process time):
      real time           0.08 seconds
      cpu time            0.10 seconds
      
91         
92         proc print data=forecasts(obs=20);
93         run;
NOTE: There were 20 observations read from the data set WORK.FORECASTS.
NOTE: The PROCEDURE PRINT printed page 2.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.02 seconds
      cpu time            0.03 seconds
      
94         
95         %studio_hide_wrapper;
106        
107