topic Re: replicate EM/Scorecard results without EM/Scorecard in Statistical Procedures

replicate EM/Scorecard results without EM/Scorecard

grezek — Tue, 13 Jul 2021 16:57:14 GMT

Is there a way to replicate the interactive binning results from Enterprise Miner/Scorecard in SAS without using Enterprise Miner. I would like to verify the results of an EM/Scorecard, specifying the variable and characteristic bins, using a proc found in Base or more probably in SAS/STAT. Any suggestions for doing this either directly or possible work around would be appreciated. Thank you in advance. -- George

Re: replicate EM/Scorecard results without EM/Scorecard

ballardw — Tue, 13 Jul 2021 19:57:02 GMT

Examples of your data and desired bins would be helpful to provide how to create the bins.

For things based on single variables Formats are one typical way to create bins.

Re: replicate EM/Scorecard results without EM/Scorecard

grezek — Wed, 14 Jul 2021 00:18:34 GMT

Thanks for following up. It is easier to see in the attached Word document. The first column has the variable, MAX_PCT_ACCTS_LAST_QTR ; the second columns contains the characteristics of the variable. Is it possible to specify these characteristics in a logistic regression other than by using EM/Scorecard? Thanks for your help. -- George

Re: replicate EM/Scorecard results without EM/Scorecard

Ksharp — Wed, 14 Jul 2021 13:32:48 GMT

Nope. You need SAS/OR to do some optimize job .

Here is what I wrote by IML for replacing EM's scorecard .

Re: replicate EM/Scorecard results without EM/Scorecard

grezek — Wed, 14 Jul 2021 15:17:22 GMT

KSharp,

What you've given here is the answer to what was going to be my next effort, replicating EM/Scorecard. This looks terrific, but I admit it will take me a while to go through it.

You did indeed answer my main question of how to specify the bins to proc logistic. In addition, you've answered so many questions and given me a sound foundation to understanding the scorecard process.

Thank you very much! -- George