Score or points allocations after building logistic regression

[deleted_user]

I came up with a logistic regression using EG. I transformed the probability to score using the following equation: score=Log(odds) * factor + offset

Now, I need to come up wtih the points or score allocation. For an example, let's say if age < 30, then the account will get points of 7. For age >=30, it will get 12 points. I heard I have to use weight of evidence. I'm wondering if there is a SAS option to do that quickly.

[Andy361]

My colleagues and I built a spreadsheet to do that for us. Basically you build a formula that calculates the score points off of your estimate. For example,
-XX*LOG(EXP(estimate),2) where the number XX is the value for which your score doubles in odds.

[WayneThompson · Accepted solution]

Use the Credit Scoring for EM product which provides variable selection, interactive or batch classing (binning) including weights of evidence calculations, scorecard construction with scaling and diagnostics, and reject inference.

[Andy361]

What would be great is if EM could just take the output you get from a regression node and create a scorecard without having to go through the regression steps again.

[David_Duling]

Yep. See Wayne's answer about the credit score package. Also look for the next update to the software. Thanks.

[JasonXin]

1. The exercise per se is not a modeling process. Just a transformation, if you would. Or a mapping exercise.

2. Score-carding generally is industry-specific. There is general-purpose scorecard and credit application specific score card. As Wayne indicated, for credit scoring business, it may be fairly straightforward to either use EM credit score application or run the log transformation as indicated in the spreadsheet (through Score node or just data steps). EM, however, has a much broader user base than credit risk modeling. Many users do not use log transformation to map probability scores to card allocation. If you google, you should find people focusing on all kinds of scaling exercises involving score card

3. If you really need to see a custom node (icon) in EM to conduct a focused, custom task for yourself (I know some users like to click button to get things done), consider extending EM node, although I personally believe EM SAS Code node should be easy kill for this exercise.

4. If you goal is for model performance comparison, you can use Model Import node in EM to get the probability score into EM and combine it into Model Comparison node in later steps.