BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Question
Fluorite | Level 6

 

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 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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:

 

https://communities.sas.com/t5/SAS-Statistical-Procedures/How-to-determine-logistic-regression-formu...

 

View solution in original post

2 REPLIES 2
Reeza
Super User

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:

 

https://communities.sas.com/t5/SAS-Statistical-Procedures/How-to-determine-logistic-regression-formu...

 

Question
Fluorite | Level 6

Thank You very much Reeza.. It works perfectly 🙂  I get exactly same scores as when I score automatically...

 

Alice

sas-innovate-2024.png

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.

 

Register now!

What is ANOVA?

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.

Discussion stats
  • 2 replies
  • 2181 views
  • 0 likes
  • 2 in conversation