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).
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: