Dear SAS community, Edit: My Apologies, I have amended the question. This is yet another counting with the condition that I have been struggling with. Please help! Your help would be much appreciated. Suppose that I have data below; Subject / Year / Condition A 1991 1 A 1992 1 A 1993 2 A 1994 2 A 1995 3 A 1996 1 A 1997 1 B 1991 2 B 1992 1 B 1993 2 B 1994 1 B 1995 3 B 1996 1 B 1997 2 I cannot change the order of this, and I would like to start counting when "1" appears and continue counting without counting '2' or '3' so that I get Subject / Year / Condition / Count A 1991 1 1 A 1992 1 2 A 1993 2 2 A 1994 2 2 A 1995 3 2 A 1996 1 3 A 1997 1 4 B 1991 2 0 B 1992 1 1 B 1993 2 1 B 1994 1 2 B 1995 3 2 B 1996 1 3 B 1997 2 3 How can I achieve this? Basically the end goal is to then find the number of each 1, 2, 3 and find the percentage of them to select which one I would choose based on the highest probability. But I will need to find a solution to this first. Thank you! Regards, T
... View more