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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 4804 views
  • 0 likes
  • 4 in conversation