topic SAS Macro Code for Delinquency Roll Rate Analysis in SAS Programming

SAS Macro Code for Delinquency Roll Rate Analysis

JonDickens1607 — Fri, 07 Oct 2016 21:46:43 GMT

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

Re: SAS Macro Code for Delinquency Roll Rate Analysis

Reeza — Fri, 07 Oct 2016 22:10:47 GMT

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.

Re: SAS Macro Code for Delinquency Roll Rate Analysis

ballardw — Fri, 07 Oct 2016 22:30:25 GMT

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

Re: SAS Macro Code for Delinquency Roll Rate Analysis

Ksharp — Sat, 08 Oct 2016 03:25:02 GMT

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

Re: SAS Macro Code for Delinquency Roll Rate Analysis

JonDickens1607 — Sat, 08 Oct 2016 07:22:45 GMT

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. -##

Re: SAS Macro Code for Delinquency Roll Rate Analysis

JonDickens1607 — Sat, 08 Oct 2016 07:54:12 GMT

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