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
Related Posts with Grouping multiple entries for a distinct id in longitudinal data
New program -twostep- available on SSCCourtesy of Kit Baum, the new package -twostep- by Johannes Giesecke and myself is available on SSC.…
How to show the first step of ivpoisson estimation?Greetings all, I wonder if it is possible to get the estimation of the first step conducted by the …
all possible pairwise combinations for specific companies in a specific year and in a specific country without repititionHello, I would like to find all possible pairwise combinations for specific companies in a specific …
Help on choosing the right regressionHello! I am a real beginner with Stata and would like to know if I am doing the right things, I am …
xtreg gives coefficients for outcome variablesHey dear Stata-Users! I have a question regarding xtreg: I run a regression model with different de…
Subscribe to:
Post Comments (Atom)
0 Response to Grouping multiple entries for a distinct id in longitudinal data
Post a Comment