CoxPH Example - Teradata Vantage

Input

The input table, lungcancer, contains data from a randomized trial of two treatment regimens for lung cancer used to model survival analysis. There are three categorical predictors and three numerical predictors:

In addition to a column for each predictor, the input table has these columns:

SQL Call

SELECT * FROM CoxPH (
  ON lungcancer AS InputTable
  OUT TABLE CoefficientTable (lungcancer_coef)
  OUT TABLE LinearPredictorTable (lungcancer_lp)
  USING
  FeatureColumns ('trt', 'celltype', 'karno', 'diagtime', 'age', 'prior')
  CategoricalColumns ('trt','celltype','prior')
  TimeIntervalColumn ('time_int')
  EventColumn ('status')
) AS dt;

Output

Coefficients are estimated at 95% CI. Coefficients of variables karno, squamous, and large celltype are significant.

The coefficients are output in the table lungcancer_coef, which is later used for prediction. Because celltype, trt and prior are categorical variables, one of their categories is considered a reference for the other categories; thus trt = standard, celltype = adeno, and prior = no don not show default coefficient values in each column.

This query returns the following table:

SELECT * FROM lungcancer_coef ORDER BY 1;

This query returns the following table:

SELECT * FROM lungcancer_lp ORDER BY 1;