SAS Enterprise Guide

Desktop productivity for business analysts and programmers
BookmarkSubscribeRSS Feed
mphrna1989
Calcite | Level 5

I am attempting to build a multinomial logistic model that predicts various states of a loan's performance (ie., Current, Past Due, Defaulted, Paid off). Although proc logisitc would seem like a good candidate, the issue is that prepayment has very different drivers than default/delinquency. Even though I could use a variable selection procedure, it still selects undesired variables. Ideally, I would prefer to have different sets of variables for prepayment, while preserving the joint modeling. Is there a way to do this? 

 

Thanks for any assistance you may provide.

5 REPLIES 5
PaigeMiller
Diamond | Level 26

the issue is that prepayment has very different drivers than default/delinquency

 

Regardless of what you are modelling, or what modelling method you use, this sounds to me like a perfect and justifiable reason to use different models.

--
Paige Miller
mphrna1989
Calcite | Level 5

Thanks for the feedback. The advantage of modeling the events jointly is that I could account for the correlation between paying off and defaulting. Of particular concern is that one who is likely to payoff is extremely unlikely to default. To your point, I do currently model them separately, and I do certainly see the validity in that argument.

PaigeMiller
Diamond | Level 26

If you are looking to understand and interpret the model that has been fit, I can't see one model giving good interpretability, because as you said, the drivers are different.

 

If you just want a model that predicts well, but has low interpretability, then I can see one model working.

--
Paige Miller
Reeza
Super User

I think you need to consider context here, which we don't have. 

 

Is pre-payment the one where a person has to pre-load a credit card with X amount and then borrows against it, or is it people who pre-pay their loans or pay higher amounts? 

 

Depending on what you're trying to do, perhaps you can use a stratification approach (STRATA) for the loan type? 

If it's the first case, I would say they don't fit into regular loans because the bank has already identified them as high risk. 

If it's the second, I would lean to including that as a factor/categorical variable in the model.

mphrna1989
Calcite | Level 5

Prepayment is when a borrower pays off their loan. The primary driver here would be their cost savings (ie., refinancing and getting a lower rate). So, essentially, a loan can terminate by prepaying or defaulting. Thanks.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1692 views
  • 0 likes
  • 3 in conversation