Hi all - basics of the problem are as follows:
I have a dataset with many records. Each contains 12 variables, representing the status of an account at the end of each month in a given year. Is there an easy way to compare these variables (without a lot of if - else statements).
I need to identify accounts where the status at the end of 2 consecutive months (any months, as long as they are consecutive) is GE 2.
The variables are named something like Stat_Jan, Stat_Feb etc.
Can I do this using an array? Feel sure it must be possible, but not sure how...!!
Any advice gladly received.
Chris
I have a dataset with many records. Each contains 12 variables, representing the status of an account at the end of each month in a given year. Is there an easy way to compare these variables (without a lot of if - else statements).
I need to identify accounts where the status at the end of 2 consecutive months (any months, as long as they are consecutive) is GE 2.
The variables are named something like Stat_Jan, Stat_Feb etc.
Can I do this using an array? Feel sure it must be possible, but not sure how...!!
Any advice gladly received.
Chris