SAS Macro Code for Delinquency Roll Rate Analysis

[JonDickens1607]

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

[Reeza]

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]

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]

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

[Ksharp]

I suggest you post it at IML forum, since it is about matrix operator. @Rick might have something for you .

http://blogs.sas.com/content/iml/2016/07/07/markov-transition-matrices-sasiml.html

http://blogs.sas.com/content/iml/2016/07/13/absorbing-markov-chains-in-sas.html

[JonDickens1607]

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