7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

The Lambda argument was not specified, so the function used the value of minLambda from the model table, glm2_ridge_model.

GLM2Predict Example 2 Output Table admissionspredict
id admitted lambda prediction
50 0 0.0216083135455847 0.36511507224068
52 1 0.0216083135455847 0.726496251808762
54 1 0.0216083135455847 0.717408337408593
56 1 0.0216083135455847 0.919800062501089
58 1 0.0216083135455847 0.922851378346457
60 1 0.0216083135455847 0.85873303873771
62 1 0.0216083135455847 0.920338525565984
64 1 0.0216083135455847 0.64109016094362
66 1 0.0216083135455847 0.724430371300696
68 1 0.0216083135455847 0.873776484269566
51 0 0.0216083135455847 0.367806580390766
53 1 0.0216083135455847 0.576347719419299
55 1 0.0216083135455847 0.941897375877604
57 1 0.0216083135455847 0.920293780069925
59 1 0.0216083135455847 0.859789291096852
61 1 0.0216083135455847 0.638418344069472
63 1 0.0216083135455847 0.919755040923749
65 1 0.0216083135455847 0.639825641071193
67 0 0.0216083135455847 0.295549223237937
69 1 0.0216083135455847 0.919167656796922
You can convert the prediction values that the function produced to binary predictions of admission (1 or 0) with this SQL code:
UPDATE admissionspredict 
SET prediction = 1 WHERE prediction > 0.5;

UPDATE admissionspredict 
SET prediction = 0 WHERE prediction < 0.5;
This query returns the following table:
SELECT * FROM admissionspredict;
GLM2Predict Example 2 Output Table admissionspredict
id admitted lambda prediction
52 1 0.0216083135455847 1
54 1 0.0216083135455847 1
56 1 0.0216083135455847 1
58 1 0.0216083135455847 1
60 1 0.0216083135455847 1
62 1 0.0216083135455847 1
64 1 0.0216083135455847 1
66 1 0.0216083135455847 1
68 1 0.0216083135455847 1
53 1 0.0216083135455847 1
55 1 0.0216083135455847 1
57 1 0.0216083135455847 1
59 1 0.0216083135455847 1
61 1 0.0216083135455847 1
63 1 0.0216083135455847 1
65 1 0.0216083135455847 1
69 1 0.0216083135455847 1
50 0 0.0216083135455847 0
51 0 0.0216083135455847 0
67 0 0.0216083135455847 0