From: greg6363 on
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
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