Hello List,
I have a data set where I need to group observations. The identifying flag
is two character string which can be either "01" or "02". Each "01"
observation is followed by "02", so the flag for the first obs is "01" and
the very next one's is "02". But these are always not in pair; order can be
"01" and "02"; "01", "02", "02"; "01", "02", "02, "02" and so on. All the
"02" obs. followed by "01" belong to one group. Is there any way I can
generate an identifier that indicates these groups?
Any help will be greatly appreciated.
Does this do what you want? I'm assuming that every time you encounter a
1, you want the groupid increased by 1 and to stay the same until you
encounter another 1. In this example there are 3 groups of varying sizes.