1.1 - 8.10 - ROC Syntax - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Version 1.8

SELECT * FROM ROC (
  ON { table | view | (query) } AS InputTable
  { OUT TABLE OutputTable (output_table) |
    OUT TABLE ROCTable (ROC_table) }
  USING
  [ ModelIDColumn ('model_id_column')]
  ProbabilityColumn ('probability_column')
  ObservationColumn ('observation_column')
  PositiveClass ('positive_class_label')
  [ NumThresholds (num_thresholds)]
  [ ROCValues ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
  [ AUC ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
  [ Gini ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
) AS alias;