Dear all,

This might be a trivial question, however, I am posting as I have searched multiple stata help pdfs without a relevant answer.

I am looking at a set of longitudinal data, whereby individuals have multiple values i.e
id value time
1 50 100
1 60 140
1 70 200
2 30 115
2 35 150
3 45 170
3 50 200

I am looking to categorize them into groups of >= 50 vs < 50.
However given the multiple values per indvidual, I would have
Is there a way to group them into my 2 groups of >=50 and < 50, while counting the number of distinct ids?
i.e for the dataset above, there would be 3 individuals instead of 7 observations.

Thanks for any help provided