BookmarkSubscribeRSS Feed
JonDickens1607
Obsidian | Level 7

SAS Macro Code for Delinquency Roll Rate Analysis

 

I am looking for a SAS Macro or a generic SAS Program that would enable me to construct a Roll Rate Matrix / Markov Chain Matrix

based on Delinquency Data which can then be used for Loss Forecasting in Consumer Credit Risk

 

I would appreciate any help that is available

 

Thanks

5 REPLIES 5
Reeza
Super User

Getting specific subject matter expertise is unlikely but if you post and example of your data and calculation required you can probably get some help. At least it will be faster. 

JonDickens1607
Obsidian | Level 7
Hi,

I appreciate your advice.

Thanks for responding to my request.

Basically the idea is to use empirical data to estimate the probability of
a customer changing their delinquency state within a unit of time (such as
a month) and to embed this information within a Markov Transition Matrix.

I will work on your suggestion, but in the meanwhile we can only hope...

Regards

##- Please type your reply above this line. Simple formatting, no
attachments. -##
ballardw
Super User

SAS also has a Risk Managment module that you may want to investigate.

JonDickens1607
Obsidian | Level 7

Thank you for your response to my request.

 

I have accessed and read the two DO LOOP articles published by Rick Wicklin.

 

I have also directed my initial request to Rick for his advice.

 

Regards

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 5389 views
  • 0 likes
  • 4 in conversation