Prev: How to transform datetime19. to yymm7.
Next: Why %unistats, %npcttab and Spectre-Clinical is FREE
From: greg6363 on 9 Apr 2010 16:48 I have a situation where I need some assistance. I have two datasets: one for current month performance and another one for the account level detail for a sample of accounts. After merging the two datasets, I created a new variable for months after the account has been booked (Vintage Month). Now I want to calculate delinquency percentages with this new variable. After creating a table for each past due bucket and dividing it by the total balance, I want to track that percentage for each subsequent month since the account has been booked. I tried the group by function but it's not calculating correctly. Could anyone give me suggestions on how to code this program? Any assistance would be greatly appreciated. Thanks.
From: Reeza on 9 Apr 2010 17:14 On Apr 9, 1:48 pm, greg6363 <gregtlaugh...(a)gmail.com> wrote: > I have a situation where I need some assistance. I have two > datasets: one for current month performance and another one for the > account level detail for a sample of accounts. After merging the two > datasets, I created a new variable for months after the account has > been booked (Vintage Month). Now I want to calculate delinquency > percentages with this new variable. After creating a table for each > past due bucket and dividing it by the total balance, I want to track > that percentage for each subsequent month since the account has been > booked. I tried the group by function but it's not calculating > correctly. Could anyone give me suggestions on how to code this > program? Any assistance would be greatly appreciated. Thanks. Can you post an example? Reeza
|
Pages: 1 Prev: How to transform datetime19. to yymm7. Next: Why %unistats, %npcttab and Spectre-Clinical is FREE |