CoxSurvival Example - Teradata Vantage

Input

• CoxPH Example output tables:
  • Cox_Linear_Predictor_Model_Table: lungcancer_lp
  • Cox_Coef_Model_Table: lungcancer_coef
• Predict_Table: lc_new_predictors (see CoxHazardRatio Example 1: No Reference Values)

SQL Call

SELECT * FROM CoxSurvival (
  ON lungcancer_lp AS Cox_Linear_Predictor_Model_Table
  ON lungcancer_coef AS Cox_Coef_Model_Table
  ON lc_new_predictors AS PredictTable
  OUT TABLE OutputTable (lungcancer_survival_out)
  USING
  PredictFeatureNames ('trt','celltype','karno','diagtime','age','prior')
  PredictFeatureColumns ('trt','celltype','karno','diagtime','age','prior')
  Accumulate ('id','name')
) AS dt;

Output

Survival functions are successfully generated in output table.

This query returns the following table:

SELECT * FROM lungcancer_survival_out ORDER BY 1, 3;