CoxHazardRatio Example 5: Units Values - Teradata Vantage

A standard value or unit value is a value against which an application makes comparisons. Unit values apply only to numerical variables. This example increases the variable karno by 10%, decreases the variable age by 10%, leaves the variable diagtime unchanged, and calculates the hazard ratios.

Input

• cox_coef_model: lungcancer_coef, output by CoxPH Example
• predicts: result of querying lc_new_predictors, the predicts table in CoxHazardRatio Example 1: No Reference Values

SQL Call

SELECT * FROM CoxHazardRatio (
  ON lungcancer_coef AS cox_coef_model DIMENSION
  ON (SELECT id, name, karno * (1.1) as karno,
             diagtime * (1) AS diagtime,
             age * (0.9) AS age
        FROM lc_new_predictors) AS predicts PARTITION BY 1
  USING
  PredictFeatureNames ('karno','diagtime','age')
  PredictFeatureUnitsColumns ('karno','diagtime','age')
  ACCUMULATE ('id','name')
) AS dt ORDER BY 1, 2, 3, 4, 5, 6;

Output

Numerical attributes are scaled by the unit values for comparison.