Hi,
I have built a model using proc logistic below, and I have also used the output (equation) to score new data. At the moment we were scoring in SAS but going forward to equation will have to be translated into SQL code. Could you please let me know how to interprete the euqtion below?
Thank you very much
/*Model Buid*/
proc logistic data=TRAINING outmodel=MODEL_EQUATION descending plots(only)=roc;
class age_band extended_play_band Device_DD_12w_band no_visits_12w_band time_spend_onsite_12w_band ;
model sub_target(event='1') = age_band extended_play_band Device_DD_12w_band no_visits_12w_band time_spend_onsite_12w_band / link=glogit;
score data=TRAINING out=Train_Scores;
run;
/*Score*/
proc logistic inmodel=MODEL_EQUATION;
score data=CURRENT_BASE
out=CURRENT_BASE_SCORES;
run;
_TYPE_ | _NAME_ | _CATEGORY_ | _NAMEIDX_ | _CATIDX_ | _MISC_ |
L | . | . | 10 | ||
M | NYYNYNNN | . | . | 23 | |
G | age_band | 1.<=25 | 0 | 0 | 2 |
G | age_band | 2.25 To 30 | 0 | 1 | 2 |
G | age_band | 3.30 To 35 | 0 | 2 | 2 |
G | age_band | 4.35 To 40 | 0 | 3 | 2 |
G | age_band | 5.40 To 45 | 0 | 4 | 2 |
G | age_band | 6.45 To 50 | 0 | 5 | 2 |
G | age_band | 7.50 To 55 | 0 | 6 | 2 |
G | age_band | 8.55 To 60 | 0 | 7 | 2 |
G | age_band | 9.60+ | 0 | 8 | -2 |
G | age_band | -1 | -1 | 0 | |
G | age_band | -1 | -2 | -30 | |
G | extended_play_band | 1.0 days | 1 | 0 | 2 |
G | extended_play_band | 2.1 day | 1 | 1 | 2 |
G | extended_play_band | 3.2 days | 1 | 2 | 2 |
G | extended_play_band | 4.2 To 4 days | 1 | 3 | 2 |
G | extended_play_band | 5.More than 4 days | 1 | 4 | -2 |
G | extended_play_band | -2 | -1 | 0 | |
G | extended_play_band | -2 | -2 | -30 | |
G | Device_DD_12w_band | 1.Yes | 2 | 0 | 2 |
G | Device_DD_12w_band | 2.No | 2 | 1 | -2 |
G | Device_DD_12w_band | -3 | -1 | 0 | |
G | Device_DD_12w_band | -3 | -2 | -30 | |
G | no_visits_12w_band | 1.None | 3 | 0 | 2 |
G | no_visits_12w_band | 2.1 visit | 3 | 1 | 2 |
G | no_visits_12w_band | 3.2 To 3 visits | 3 | 2 | 2 |
G | no_visits_12w_band | 4.4 To 6 visits | 3 | 3 | 2 |
G | no_visits_12w_band | 5.7 or more visits | 3 | 4 | -2 |
G | no_visits_12w_band | -4 | -1 | 0 | |
G | no_visits_12w_band | -4 | -2 | -30 | |
G | time_spend_onsite_12w_band | 1.2min | 4 | 0 | 2 |
G | time_spend_onsite_12w_band | 2.5 min | 4 | 1 | 2 |
G | time_spend_onsite_12w_band | 3.15 min | 4 | 2 | 2 |
G | time_spend_onsite_12w_band | 4.40 min | 4 | 3 | 2 |
G | time_spend_onsite_12w_band | 5.1h 30 min | 4 | 4 | 2 |
G | time_spend_onsite_12w_band | 6.More than 1 h 30 | 4 | 5 | -2 |
G | time_spend_onsite_12w_band | -5 | -1 | 0 | |
G | time_spend_onsite_12w_band | -5 | -2 | -30 | |
G | sub_target | 1 | 5 | 0 | 11 |
G | sub_target | 0 | 5 | 1 | -11 |
G | sub_target | -6 | 0 | 962 | |
G | sub_target | -6 | 1 | 8657 | |
G | sub_target | -6 | -2 | -12 | |
E | Intercept | E | 0 | 0 | -1.989606292 |
E | EFFECT | G | 0 | 0 | 0 |
E | EFFECT | X | 0 | 0 | 0 |
E | EFFECT | E | 0 | 0 | 0.609907938 |
E | EFFECT | E | 0 | 1 | 0.608616265 |
E | EFFECT | E | 0 | 2 | 0.324517086 |
E | EFFECT | E | 0 | 3 | 0.208340512 |
E | EFFECT | E | 0 | 4 | -0.133391473 |
E | EFFECT | E | 0 | 5 | -0.254415291 |
E | EFFECT | E | 0 | 6 | -0.348959221 |
E | EFFECT | E | 0 | 7 | -0.328500202 |
E | EFFECT | G | 1 | 0 | 1 |
E | EFFECT | X | 1 | 0 | 1 |
E | EFFECT | E | 1 | 0 | -0.373354935 |
E | EFFECT | E | 1 | 1 | -0.522159127 |
E | EFFECT | E | 1 | 2 | -0.266655139 |
E | EFFECT | E | 1 | 3 | 0.248943742 |
E | EFFECT | G | 2 | 0 | 2 |
E | EFFECT | X | 2 | 0 | 2 |
E | EFFECT | E | 2 | 0 | 0.187089275 |
E | EFFECT | G | 3 | 0 | 3 |
E | EFFECT | X | 3 | 0 | 3 |
E | EFFECT | E | 3 | 0 | -0.049154591 |
E | EFFECT | E | 3 | 1 | 0.345175518 |
E | EFFECT | E | 3 | 2 | 0.232629562 |
E | EFFECT | E | 3 | 3 | -0.129418109 |
E | EFFECT | G | 4 | 0 | 4 |
E | EFFECT | X | 4 | 0 | 4 |
E | EFFECT | E | 4 | 0 | -0.17159942 |
E | EFFECT | E | 4 | 1 | 0.196868737 |
E | EFFECT | E | 4 | 2 | 0.148384306 |
E | EFFECT | E | 4 | 3 | 0.075433201 |
E | EFFECT | E | 4 | 4 | 0.034985814 |
E | EFFECT | V | . | 0 | 0.004451947 |
E | EFFECT | V | . | 1 | 0.000568076 |
E | EFFECT | V | . | 2 | 0.014954355 |
E | EFFECT | V | . | 3 | -0.000129658 |
E | EFFECT | V | . | 4 | -0.001528856 |
E | EFFECT | V | . | 5 | 0.010736189 |
E | EFFECT | V | . | 6 | -0.000270416 |
E | EFFECT | V | . | 7 | -0.001456796 |
E | EFFECT | V | . | 8 | -0.000882231 |
E | EFFECT | V | . | 9 | 0.008960256 |
E | EFFECT | V | . | 10 | -0.000519628 |
E | EFFECT | V | . | 11 | -0.001473351 |
E | EFFECT | V | . | 12 | -0.000859936 |
E | EFFECT | V | . | 13 | -0.000678084 |
E | EFFECT | V | . | 14 | 0.008033365 |
E | EFFECT | V | . | 15 | -0.000319231 |
E | EFFECT | V | . | 16 | -0.001759276 |
E | EFFECT | V | . | 17 | -0.001155112 |
E | EFFECT | V | . | 18 | -0.000910213 |
E | EFFECT | V | . | 19 | -0.000763817 |
E | EFFECT | V | . | 20 | 0.009088793 |
E | EFFECT | V | . | 21 | -0.000267753 |
E | EFFECT | V | . | 22 | -0.001775369 |
E | EFFECT | V | . | 23 | -0.001169047 |
E | EFFECT | V | . | 24 | -0.00090607 |
E | EFFECT | V | . | 25 | -0.000731201 |
E | EFFECT | V | . | 26 | -0.000837189 |
E | EFFECT | V | . | 27 | 0.008640499 |
E | EFFECT | V | . | 28 | 0.000147963 |
E | EFFECT | V | . | 29 | -0.002094687 |
E | EFFECT | V | . | 30 | -0.001486877 |
E | EFFECT | V | . | 31 | -0.001197141 |
E | EFFECT | V | . | 32 | -0.001012982 |
E | EFFECT | V | . | 33 | -0.001098766 |
E | EFFECT | V | . | 34 | -0.000978575 |
E | EFFECT | V | . | 35 | 0.010499309 |
E | EFFECT | V | . | 36 | 0.000545479 |
E | EFFECT | V | . | 37 | -0.002564363 |
E | EFFECT | V | . | 38 | -0.001954651 |
E | EFFECT | V | . | 39 | -0.001602579 |
E | EFFECT | V | . | 40 | -0.001399642 |
E | EFFECT | V | . | 41 | -0.001435222 |
E | EFFECT | V | . | 42 | -0.001287284 |
E | EFFECT | V | . | 43 | -0.001486063 |
E | EFFECT | V | . | 44 | 0.013066396 |
E | EFFECT | V | . | 45 | 0.001392132 |
E | EFFECT | V | . | 46 | -0.000662184 |
E | EFFECT | V | . | 47 | -0.000729924 |
E | EFFECT | V | . | 48 | -0.000500487 |
E | EFFECT | V | . | 49 | -0.000074663 |
E | EFFECT | V | . | 50 | 0.00018812 |
E | EFFECT | V | . | 51 | 0.000346121 |
E | EFFECT | V | . | 52 | 0.000479063 |
E | EFFECT | V | . | 53 | 0.000489094 |
E | EFFECT | V | . | 54 | 0.009480596 |
E | EFFECT | V | . | 55 | 5.76884E-05 |
E | EFFECT | V | . | 56 | -0.000325705 |
E | EFFECT | V | . | 57 | -0.000375672 |
E | EFFECT | V | . | 58 | -0.000237197 |
E | EFFECT | V | . | 59 | -0.000216465 |
E | EFFECT | V | . | 60 | 2.32136E-05 |
E | EFFECT | V | . | 61 | 0.000138117 |
E | EFFECT | V | . | 62 | 0.000272522 |
E | EFFECT | V | . | 63 | 0.000277609 |
E | EFFECT | V | . | 64 | -0.001641732 |
E | EFFECT | V | . | 65 | 0.004604625 |
E | EFFECT | V | . | 66 | 0.000890715 |
E | EFFECT | V | . | 67 | -0.000303457 |
E | EFFECT | V | . | 68 | -8.44E-06 |
E | EFFECT | V | . | 69 | 0.000127129 |
E | EFFECT | V | . | 70 | -0.000023587 |
E | EFFECT | V | . | 71 | -0.000134442 |
E | EFFECT | V | . | 72 | -0.000134375 |
E | EFFECT | V | . | 73 | -0.000089133 |
E | EFFECT | V | . | 74 | 0.000254368 |
E | EFFECT | V | . | 75 | -0.002856435 |
E | EFFECT | V | . | 76 | -0.00129968 |
E | EFFECT | V | . | 77 | 0.00779224 |
E | EFFECT | V | . | 78 | -0.001286215 |
E | EFFECT | V | . | 79 | 0.000536738 |
E | EFFECT | V | . | 80 | 0.000307785 |
E | EFFECT | V | . | 81 | 0.000138815 |
E | EFFECT | V | . | 82 | 6.88791E-05 |
E | EFFECT | V | . | 83 | -0.000127788 |
E | EFFECT | V | . | 84 | -0.000030966 |
E | EFFECT | V | . | 85 | -0.000289437 |
E | EFFECT | V | . | 86 | -0.000324579 |
E | EFFECT | V | . | 87 | -0.003135854 |
E | EFFECT | V | . | 88 | -0.001356534 |
E | EFFECT | V | . | 89 | -0.002295489 |
E | EFFECT | V | . | 90 | 0.007292882 |
E | EFFECT | V | . | 91 | 0.002595577 |
E | EFFECT | V | . | 92 | 0.000253242 |
E | EFFECT | V | . | 93 | 0.000134431 |
E | EFFECT | V | . | 94 | 3.17489E-05 |
E | EFFECT | V | . | 95 | -0.000127727 |
E | EFFECT | V | . | 96 | -0.000196204 |
E | EFFECT | V | . | 97 | -0.000128691 |
E | EFFECT | V | . | 98 | 7.41017E-05 |
E | EFFECT | V | . | 99 | -0.000061406 |
E | EFFECT | V | . | 100 | 0.000907522 |
E | EFFECT | V | . | 101 | 0.000727013 |
E | EFFECT | V | . | 102 | 0.000436183 |
E | EFFECT | V | . | 103 | -0.001800096 |
E | EFFECT | V | . | 104 | 0.003386082 |
E | EFFECT | V | . | 105 | -0.001097715 |
E | EFFECT | V | . | 106 | -0.000385195 |
E | EFFECT | V | . | 107 | -0.000182626 |
E | EFFECT | V | . | 108 | -0.000278222 |
E | EFFECT | V | . | 109 | -0.000076404 |
E | EFFECT | V | . | 110 | 4.56044E-05 |
E | EFFECT | V | . | 111 | 0.000135544 |
E | EFFECT | V | . | 112 | 0.000255716 |
E | EFFECT | V | . | 113 | 0.000127127 |
E | EFFECT | V | . | 114 | -0.000052143 |
E | EFFECT | V | . | 115 | -0.000097682 |
E | EFFECT | V | . | 116 | -0.000047106 |
E | EFFECT | V | . | 117 | 0.000107029 |
E | EFFECT | V | . | 118 | -0.000109514 |
E | EFFECT | V | . | 119 | 0.004405613 |
E | EFFECT | V | . | 120 | -0.00026463 |
E | EFFECT | V | . | 121 | -0.000398048 |
E | EFFECT | V | . | 122 | -0.000318491 |
E | EFFECT | V | . | 123 | -0.000049796 |
E | EFFECT | V | . | 124 | 9.71719E-05 |
E | EFFECT | V | . | 125 | -0.000022216 |
E | EFFECT | V | . | 126 | 2.31968E-05 |
E | EFFECT | V | . | 127 | 0.000187958 |
E | EFFECT | V | . | 128 | 0.000240991 |
E | EFFECT | V | . | 129 | -0.000510874 |
E | EFFECT | V | . | 130 | 4.28724E-05 |
E | EFFECT | V | . | 131 | -5.21E-06 |
E | EFFECT | V | . | 132 | 0.000209985 |
E | EFFECT | V | . | 133 | -0.000272214 |
E | EFFECT | V | . | 134 | -0.00089094 |
E | EFFECT | V | . | 135 | 0.006585419 |
E | EFFECT | V | . | 136 | -0.000032897 |
E | EFFECT | V | . | 137 | -0.000096658 |
E | EFFECT | V | . | 138 | -0.000051461 |
E | EFFECT | V | . | 139 | -0.000076673 |
E | EFFECT | V | . | 140 | 2.42103E-05 |
E | EFFECT | V | . | 141 | -8.60E-06 |
E | EFFECT | V | . | 142 | -0.000090536 |
E | EFFECT | V | . | 143 | -0.000050168 |
E | EFFECT | V | . | 144 | 0.000277658 |
E | EFFECT | V | . | 145 | -0.000155073 |
E | EFFECT | V | . | 146 | -0.000048636 |
E | EFFECT | V | . | 147 | 8.75763E-05 |
E | EFFECT | V | . | 148 | 0.000189359 |
E | EFFECT | V | . | 149 | -0.000141328 |
E | EFFECT | V | . | 150 | -0.000791904 |
E | EFFECT | V | . | 151 | -0.001177084 |
E | EFFECT | V | . | 152 | 0.005011082 |
E | EFFECT | V | . | 153 | 0.000963221 |
E | EFFECT | V | . | 154 | 0.00025336 |
E | EFFECT | V | . | 155 | 7.19285E-05 |
E | EFFECT | V | . | 156 | 0.000019043 |
E | EFFECT | V | . | 157 | -0.00016052 |
E | EFFECT | V | . | 158 | -0.000064137 |
E | EFFECT | V | . | 159 | 0.000094084 |
E | EFFECT | V | . | 160 | -0.00020199 |
E | EFFECT | V | . | 161 | 4.11728E-05 |
E | EFFECT | V | . | 162 | 0.000130558 |
E | EFFECT | V | . | 163 | 0.000152036 |
E | EFFECT | V | . | 164 | 0.000201972 |
E | EFFECT | V | . | 165 | 8.84796E-05 |
E | EFFECT | V | . | 166 | 0.000148416 |
E | EFFECT | V | . | 167 | -0.001500705 |
E | EFFECT | V | . | 168 | -0.002239131 |
E | EFFECT | V | . | 169 | -0.001498889 |
E | EFFECT | V | . | 170 | 0.006723426 |
E | EFFECT | V | . | 171 | 0.00363831 |
E | EFFECT | V | . | 172 | -0.000688501 |
E | EFFECT | V | . | 173 | -0.000074329 |
E | EFFECT | V | . | 174 | -0.00015348 |
E | EFFECT | V | . | 175 | -0.000145269 |
E | EFFECT | V | . | 176 | 3.08E-06 |
E | EFFECT | V | . | 177 | 0.000184652 |
E | EFFECT | V | . | 178 | 0.000348334 |
E | EFFECT | V | . | 179 | 0.000464245 |
E | EFFECT | V | . | 180 | -0.000409315 |
E | EFFECT | V | . | 181 | 0.000196919 |
E | EFFECT | V | . | 182 | 7.68497E-05 |
E | EFFECT | V | . | 183 | 2.52648E-05 |
E | EFFECT | V | . | 184 | 0.00017209 |
E | EFFECT | V | . | 185 | -0.002815374 |
E | EFFECT | V | . | 186 | 0.000336714 |
E | EFFECT | V | . | 187 | 0.000762319 |
E | EFFECT | V | . | 188 | 0.000751589 |
E | EFFECT | V | . | 189 | 0.02308276 |
E | EFFECT | V | . | 190 | 0.000602567 |
E | EFFECT | V | . | 191 | 0.000264291 |
E | EFFECT | V | . | 192 | -0.00053944 |
E | EFFECT | V | . | 193 | 5.11117E-05 |
E | EFFECT | V | . | 194 | -0.000327257 |
E | EFFECT | V | . | 195 | 7.38967E-05 |
E | EFFECT | V | . | 196 | -0.000093565 |
E | EFFECT | V | . | 197 | 4.44893E-05 |
E | EFFECT | V | . | 198 | 0.000232133 |
E | EFFECT | V | . | 199 | -0.001135944 |
E | EFFECT | V | . | 200 | 0.00058486 |
E | EFFECT | V | . | 201 | 0.000153368 |
E | EFFECT | V | . | 202 | 0.000340918 |
E | EFFECT | V | . | 203 | -0.00019499 |
E | EFFECT | V | . | 204 | -0.000265338 |
E | EFFECT | V | . | 205 | -0.001929143 |
E | EFFECT | V | . | 206 | -0.00005421 |
E | EFFECT | V | . | 207 | 0.000959489 |
E | EFFECT | V | . | 208 | -0.005125481 |
E | EFFECT | V | . | 209 | 0.013170579 |
E | EFFECT | V | . | 210 | -0.001001999 |
E | EFFECT | V | . | 211 | 0.000112427 |
E | EFFECT | V | . | 212 | 5.12976E-05 |
E | EFFECT | V | . | 213 | 1.85E-06 |
E | EFFECT | V | . | 214 | -0.000141305 |
E | EFFECT | V | . | 215 | 0.000028918 |
E | EFFECT | V | . | 216 | -0.000040637 |
E | EFFECT | V | . | 217 | -0.000151469 |
E | EFFECT | V | . | 218 | -0.000035142 |
E | EFFECT | V | . | 219 | 1.38339E-05 |
E | EFFECT | V | . | 220 | 7.81228E-05 |
E | EFFECT | V | . | 221 | 3.09595E-05 |
E | EFFECT | V | . | 222 | 9.64817E-05 |
E | EFFECT | V | . | 223 | -0.000092614 |
E | EFFECT | V | . | 224 | 0.000508186 |
E | EFFECT | V | . | 225 | -0.000856441 |
E | EFFECT | V | . | 226 | -0.000937477 |
E | EFFECT | V | . | 227 | 8.40506E-05 |
E | EFFECT | V | . | 228 | -0.004233821 |
E | EFFECT | V | . | 229 | -0.001280689 |
E | EFFECT | V | . | 230 | 0.006383157 |
E | EFFECT | V | . | 231 | -0.001298108 |
E | EFFECT | V | . | 232 | 0.00027481 |
E | EFFECT | V | . | 233 | 0.000246307 |
E | EFFECT | V | . | 234 | 6.06E-06 |
E | EFFECT | V | . | 235 | 3.81694E-05 |
E | EFFECT | V | . | 236 | -0.000181544 |
E | EFFECT | V | . | 237 | -0.000046325 |
E | EFFECT | V | . | 238 | -0.000017635 |
E | EFFECT | V | . | 239 | -0.000192028 |
E | EFFECT | V | . | 240 | 0.000347613 |
E | EFFECT | V | . | 241 | 1.56007E-05 |
E | EFFECT | V | . | 242 | 7.11752E-05 |
E | EFFECT | V | . | 243 | -0.000166833 |
E | EFFECT | V | . | 244 | 2.62068E-05 |
E | EFFECT | V | . | 245 | 0.000704728 |
E | EFFECT | V | . | 246 | 0.00037034 |
E | EFFECT | V | . | 247 | -0.00048812 |
E | EFFECT | V | . | 248 | -0.000833255 |
E | EFFECT | V | . | 249 | -0.004167523 |
E | EFFECT | V | . | 250 | -0.00162104 |
E | EFFECT | V | . | 251 | 0.000330732 |
E | EFFECT | V | . | 252 | 0.005076467 |
E | EFFECT | V | . | 253 | -0.001143516 |
E | EFFECT | V | . | 254 | -8.71E-06 |
E | EFFECT | V | . | 255 | 0.000102476 |
E | EFFECT | V | . | 256 | 3.31019E-05 |
E | EFFECT | V | . | 257 | 0.000246055 |
E | EFFECT | V | . | 258 | 1.11997E-05 |
E | EFFECT | V | . | 259 | -0.000048674 |
E | EFFECT | V | . | 260 | 3.83547E-05 |
E | EFFECT | V | . | 261 | -0.000198024 |
E | EFFECT | V | . | 262 | 0.000597985 |
E | EFFECT | V | . | 263 | -0.000174258 |
E | EFFECT | V | . | 264 | -0.000101014 |
E | EFFECT | V | . | 265 | -0.000334283 |
E | EFFECT | V | . | 266 | 0.000149422 |
E | EFFECT | V | . | 267 | 0.000910072 |
E | EFFECT | V | . | 268 | 0.000929281 |
E | EFFECT | V | . | 269 | 0.000119781 |
E | EFFECT | V | . | 270 | -0.000767318 |
E | EFFECT | V | . | 271 | -0.004485862 |
E | EFFECT | V | . | 272 | -0.002198412 |
E | EFFECT | V | . | 273 | -0.000202533 |
E | EFFECT | V | . | 274 | 0.000517959 |
E | EFFECT | V | . | 275 | 0.005976145 |
X | 354 | 164 | 38091 | 9918.133105 |
1. Use the CODE statement within PROC LOGISTIC to get the data step scoring code. These are basic calculations so you should be able to convert your datastep to a SQL step relatively easily.
Here's an example of a full 'manual' process:
1. Use the CODE statement within PROC LOGISTIC to get the data step scoring code. These are basic calculations so you should be able to convert your datastep to a SQL step relatively easily.
Here's an example of a full 'manual' process:
Thank You very much Reeza.. It works perfectly 🙂 I get exactly same scores as when I score automatically...
Alice
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.