CoxHazardRatio Example 2: No Reference Values, Partition by Name or ID - Teradata Vantage

The input table can be partitioned by either name or id and the hazard ratio is determined. Because reference values are not used in this example, partitioning by id gives the same result as identity comparison (that is, the patients are compared with themselves and the hazard ratio is one).

Input

• cox_coef_model: lungcancer_coef, output by CoxPH Example
• predicts: lc_new_predictors, as in CoxHazardRatio Example 1: No Reference Values

SQL Call

SELECT * FROM CoxHazardRatio (
  ON lungcancer_coef AS cox_coef_model DIMENSION
  ON lc_new_predictors AS predicts PARTITION BY name, id
  USING
  PredictFeatureNames ('trt','celltype','karno','diagtime','age','prior')
  PredictFeatureColumns ('trt','celltype','karno','diagtime','age','prior')
  Accumulate ('id','name')
) AS dt ORDER BY 1, 2, 3, 4, 5, 6, 7, 8;

Output