topic Re: Score or points allocations after building logistic regression in SAS Data Science

Score or points allocations after building logistic regression

deleted_user — Wed, 11 Nov 2009 02:55:38 GMT

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.

Re: Score or points allocations after building logistic regression

Andy361 — Tue, 15 Jun 2010 17:25:15 GMT

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.

Re: Score or points allocations after building logistic regression

WayneThompson — Fri, 07 Jul 2017 19:12:24 GMT

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.

Re: Score or points allocations after building logistic regression

Andy361 — Wed, 21 Jul 2010 17:24:45 GMT

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.

Re: Score or points allocations after building logistic regression

David_Duling — Wed, 21 Jul 2010 17:29:35 GMT

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

Re: Score or points allocations after building logistic regression

JasonXin — Sun, 12 Aug 2012 11:59:30 GMT

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.