7.00.02 - Odds Ratio and Confidence Intervals - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)

You can exponentiate the coefficients (the estimate column in the output table coefficient estimates) and interpret them as odds ratios (ORs). To perform this type of computation, you can run the following SQL queries on the output of the GLM function.

-- odds ratios only
SELECT predictor, category,
  EXP(estimate) AS odds_ratio
  FROM glm_output;
-- odds ratios and 95% CI
SELECT predictor, category,
  EXP(estimate) AS odds_ratio,
  EXP(estimate - 1.96 * std_err) AS lower_bound,
  EXP(estimate + 1.96 * std_err) AS upper_bound
FROM glm_output;