I have the complete data like

id time censor
1 10 0
1 20 0
1 30 0
2 10 0
2 20 1
2 30 0
2 40 0
3 10 0
3 20 0
3 30 1
....

for id 1, i want to select the last row since all censor indicator is 0; for
id 2, i want to select the row where censor ==1; for id 3, i also want to
select the row where censor==1. So if there is a 1 for censor, then I want
to select such a row, otherwise I want to select the last obs. for this id.
I am wondering if there is a quick way to solve this?

	[[alternative HTML version deleted]]

