Input
model_id id observation probability -------- --- ----------- ------------ 1 7 0 0.15 1 40 0 0.4 1 55 1 1.0 1 57 1 0.85 1 72 1 1.0 1 80 1 0.9 1 95 1 1.0 1 110 0 0.0 1 112 0 0.0 1 118 0 0.0 1 120 1 0.9 1 127 0 0.0 1 135 0 0.0 1 150 0 0.1 1 158 1 1.0 1 162 0 0.05 1 167 0 0.0 1 173 0 0.0 1 175 0 0.0 1 190 1 0.9 1 200 0 0.0 1 213 1 0.1 1 217 0 0.0 1 223 1 1.0 1 228 0 0.0 2 230 0 0.05 2 240 0 0.0 2 255 0 0.0 2 268 1 1.0 2 270 1 1.0 2 272 1 1.0 2 278 1 0.9 2 295 1 1.0 2 310 1 0.9 2 343 0 0.0 2 345 0 0.05 2 360 0 0.15 2 383 1 1.0 2 398 0 0.3 2 400 1 0.95 2 406 0 0.0 2 415 0 0.0 2 423 0 0.0 2 438 0 0.0 2 446 1 1.0 2 453 0 0.0 2 455 0 0.05 2 461 0 0.1 2 463 0 0.0 2 478 1 0.85 3 488 1 0.75 3 493 1 1.0 3 501 1 1.0 3 503 0 0.4 3 505 0 0.35 3 516 0 0.0 3 518 0 0.0 3 528 0 0.15 3 533 1 0.9 3 543 1 0.7 3 556 1 0.7 3 558 1 1.0 3 560 1 0.95 3 575 1 0.35 3 583 0 0.0 3 598 1 1.0 3 615 1 0.45 3 631 1 1.0 3 648 1 0.9 3 671 0 0.05 3 686 0 0.0 3 688 0 0.1 3 703 0 0.0 3 711 0 0.8 3 718 0 0.15 4 726 1 1.0 4 734 0 0.05 4 741 1 0.4 4 743 0 0.05 4 749 0 0.0 4 751 0 0.0 4 758 0 0.0 4 766 1 0.85 4 781 0 0.7 4 789 0 0.1 4 791 1 0.7 4 793 1 1.0 4 798 0 0.0 4 804 1 1.0 4 806 0 0.0 4 808 1 0.9 4 821 1 1.0 4 831 0 0.0 4 846 0 0.0 4 848 0 0.0 4 861 1 0.8 4 863 0 0.05 4 886 0 0.3 4 901 0 0.0 4 903 0 0.0
SQL Call
In this call, the ROCValues, AUC, and Gini syntax elements default to the values 'true', 'false', and 'false', respectively.
SELECT * FROM ROC ( ON roc_input AS InputTable OUT TABLE OutputTable (roc_out_1) USING ModelIdColumn ('model_id') ProbabilityColumn ('probability') ObservationColumn ('observation') PositiveClass ('1') NumThresholds (100) ) AS dt;
Output
info ------------- ROC complete.
SELECT * FROM roc_out_1;
model_id threshold tpr fpr -------- ------------------ ----------------- ------------------ 1 0.0 1.0 1.0 1 0.0101010101010101 1.0 0.266666666666667 1 0.0202020202020202 1.0 0.266666666666667 1 0.0303030303030303 1.0 0.266666666666667 1 0.0404040404040404 1.0 0.266666666666667 ... 2 0.0 1.0 1.0 2 0.0101010101010101 1.0 0.4 2 0.0202020202020202 1.0 0.4 2 0.0303030303030303 1.0 0.4 2 0.0404040404040404 1.0 0.4 ... 3 0.0 1.0 1.0 3 0.0101010101010101 1.0 0.583333333333333 3 0.0202020202020202 1.0 0.583333333333333 3 0.0303030303030303 1.0 0.583333333333333 3 0.0404040404040404 1.0 0.583333333333333 ... 4 0.0 1.0 1.0 4 0.0101010101010101 1.0 0.375 4 0.0202020202020202 1.0 0.375 4 0.0303030303030303 1.0 0.375 4 0.0404040404040404 1.0 0.375 ...
Download a zip file of all examples and a SQL script file that creates their input tables.