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 ... View more

Hi,   I have the table below, customer_id and the subscription date. I want to add another field showing the Saturday date before the sub date.   Your help would be much appreciated.   Thank You very much     Have       customer_id sub_table_date     50095 22-Dec-15     50206 10-Jan-16     50220 26-May-16                     Want       customer_id sub_table_date Saturday_before_dt   50095 22-Dec-15 19-Dec-15   50206 10-Jan-16 04-Jun-16   50220 26-May-16 21-May-16 ... View more

Hi All,   I would like to create the fiewl week_return based on the tranasaction dates. For axmple this customer reatuns after 1 week, then after 2 weeks etc..Your help would be much appreciated.   Thank You   customer_id WEEK_NO Trans_date weekly_latest_Sales Week_return 50026 1 06-Jan-17 31,000,000   50026 2 13-Jan-17 53,000,000 1 50026 7 14-Feb-17 39,000,000 5 50026 10 10-Mar-17 64,000,000 3 50026 11 14-Mar-17 70,000,000 1 50026 13 31-Mar-17 49,000,000 2 ... View more