Hi,
I have a dataset with variable names M1 - M48 ( where M specifies month) and have DPD Buckets (0-DPD, 1-30 DPD, 31-60 DPD, 61-90 DPD and 91+ DPD) as values. I want to create a transition matrix for these DPD BUCKETS comparing Year-On-Year movement of DPD Buckets. This needs to be done for every M: variable
For eg: Create transition Matrix for M1 and M13, M2 and M14, M3 and M15 and so on. The output expected is:
M1\M13 | 0 DPD | 1 - 30 DPD | 31 - 60 DPD | 61 - 90 DPD | 91+ DPD | Closed |
0 DPD | 123 | 0 | 3 | 1 | 5 | 57 |
1 - 30 DPD | 0 | 0 | 0 | 0 | 0 | 0 |
31 - 60 DPD | 2 | 0 | 0 | 0 | 2 | 4 |
61 - 90 DPD | 1 | 0 | 0 | 0 | 2 | 0 |
91+ DPD | 1 | 0 | 0 | 1 | 58 | 5 |
If I do this using Proc FREQ then how can I create transition matrix on the above mentioned incremental data. Or is there any better way to achieve this output.
Please Suggest!
Where did "closed" come from? You made no mention of it.
Do you want this in the form of a report? Do you want actual counts, or do you want row percentages (after all this is a "transition" matrix - you may want to look at proportion of each row (M1 value) ending up in a given column (M13 value).
Or, do you want this in the form of a dataset?
Please provide, in the form of a data step, a sample of your data (say just M1, M2, M3, M13, M14, and M14).
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.