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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.