Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Score or points allocations after building logistic regression

Accepted Solution Solved
Reply
N/A
Posts: 0
Accepted Solution

Score or points allocations after building logistic regression

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.

Accepted Solutions
Solution
‎07-07-2017 03:11 PM
SAS Employee
Posts: 31

Re: Score or points allocations after building logistic regression

[ Edited ]
Posted in reply to deleted_user

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.

View solution in original post


All Replies
New Contributor
Posts: 4

Re: Score or points allocations after building logistic regression

Posted in reply to deleted_user
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.
Solution
‎07-07-2017 03:11 PM
SAS Employee
Posts: 31

Re: Score or points allocations after building logistic regression

[ Edited ]
Posted in reply to deleted_user

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.

New Contributor
Posts: 4

Re: Score or points allocations after building logistic regression

Posted in reply to WayneThompson
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.
SAS Employee
Posts: 35

Re: Score or points allocations after building logistic regression

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

Re: Score or points allocations after building logistic regression

Posted in reply to David_Duling

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 2669 views
  • 0 likes
  • 5 in conversation