Odds Ratio and Confidence Intervals - Teradata Vantage

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;