@jshingwng wrote: I see. I could transpose my data from wide to long. But how would I set the condition following this logic? --> if as at Status31Jan2007 = 1 and the following two months, count of Status fields with 0 > 0, then flag it as 'Y'. Else, N.   How do I count the Status fields for the next 2 months as at each field?  Before transposing perhaps. But would need an actual example as this seems to have the potential to add a bunch of variables.   Or perhaps you might be wanting some sort of Proc IML (matrix) solution. An actual concrete example worked for a small number of records and variables would help.     ... View more