If you specify OutputTable, the function outputs a message and creates OutputTable. The OutputTable schema depends on the ROCValues syntax element.
Output Message Schema
Column | Data Type | Description |
---|---|---|
info | VARCHAR | Reports whether function completed. |
OutputTable Schema, ROCValues ('true') (Default)
The table has one row for each threshold for each model, and contains only ROC values.
Column | Data Type | Description |
---|---|---|
model | Same as model_id_column in input table | [Column appears only with ModelIDColumn syntax element.] Model identifier or partition for ROC curve associated with observation, taken from model_id_column. |
threshold | DOUBLE PRECISION | Threshold at which function classifies an observation as positive. |
tpr | DOUBLE PRECISION | True positive rate for threshold (number of observations correctly predicted as positive based on threshold, divided by number of observations known to be positive). |
fpr | DOUBLE PRECISION | False positive rate for threshold (number of observations incorrectly predicted as positive based on threshold, divided by number of observations known to be negative). |
OutputTable Schema, ROCValues ('false')
This is the default output table if you specify AUC only, Gini only, or AUC and Gini only.
The table has the following:
- One row for each model
- No ROC values
- AUC values, Gini values, or both (depending on AUC and Gini syntax elements)
Column | Data Type | Description |
---|---|---|
model | Same as model_id_column in input table | [Column appears only with ModelIDColumn syntax element.] Model identifier or partition for ROC curve associated with observation, taken from model_id_column. |
AUC | DOUBLE PRECISION | Area under ROC curve for data in partition. With AUC ( 'false'), this value is NULL. |
Gini | DOUBLE PRECISION | Gini coefficient for ROC curve for data in partition. With Gini ('false'), this value is NULL. |