GLM2Predict Example 1: Elastic Net for Gaussian Regression Prediction - Teradata Vantage

Input

• Input table: glm2_elastic_net, as in GLM2 Example 3: Elastic Net for Gaussian Regression Analysis
• Model table: glm2_elastic_net_model, output by Example 3

SQL Call

SELECT * FROM GLM2Predict (
  ON glm2_elastic_net AS "input" PARTITION BY ANY
  ON glm2_elastic_net_model AS "model" DIMENSION ORDER BY "category"
  USING
  Accumulate ('id', 'employed')
) AS dt;

Output

For each input table row, the output has a predicted value and the value of lambda used for the prediction. The Lambda argument was not specified, so the function used the MinLambda value from the model table, glm2_elastic_net_model.