GLMPredictPerSegment Example: Regression, Family ('BINOMIAL') | Teradata Vantage - GLMPredictPerSegment Example: Logistic Regression, Family ('BINOMIAL') - Teradata Vantage

Input

• admissions_test, as in GLMPredict_MLE Example: Logistic Distribution Prediction
• glm_ps_admission, output by GLMPerSegment Example: Logical Regression, Family ('BINOMIAL')

SQL Call

SELECT * FROM GLMPredictPerSegment (
  ON admissions_test PARTITION BY masters
  ON glm_ps_admission AS Model PARTITION BY masters
  USING
  Accumulate ('id','masters','admitted') 
  OutputProb ('t')
) AS dt ORDER BY id;

Output

id masters admitted prediction prob               error_code 
-- ------- -------- ---------- ------------------ ---------- 
50 yes            0 0          0.7557199737086269 NULL      
51 yes            0 0          0.7383527456399348 NULL      
52 no             1 1           0.999925036619523 NULL      
53 yes            1 1          0.8099636753722493 NULL      
54 yes            1 1          0.6860262600792199 NULL      
55 no             1 1          0.9997294677346087 NULL      
...