Hi!
I'm working with data collected in 2002 (round 1), 2007 (round 2) and 2017 (round 3). I want to drop all the observations that participated in only one ofte the rounds, and only keep observations where the participant participated in two or three rounds.
I have a variable that indicates the reference number (ref_nr) of the participant. So in other words, if a person participated in both round 2 and 3, he or she will have the same reference number in both rounds.
I'm therefore wondering how I should write the command? I know the following commands doesn't work, but I'll write them as examples for you to understand what I'm after:
drop if ref_nr appear once
Or on the other side:
keep if ref_nr appear more than once
Thanks in advance!
Related Posts with Problem with dropping observations in longitudinal study
Bootstrapping? - Comparing the within-subject treatment effect with the between-subject treatment effect (based on two other groups)Dear fellow Stata users, thank you very much for reading my post. I am currently working on an inte…
Collecting Confidence Intervals from regress using statsbyHi. I want to use statsby to collect the lower and upper limits of the 95% confidence interval of a …
coefplot using "meta-data"Hi all, (Relatively new STATA user here) I'm trying some interesting ways of visualizing my data and…
WTP pack with categorical variable in choice experimentHello, running a mixed logit model and have one categorical variable with three levels/categories. W…
Generating Date IssueHello Statalist, I am having trouble converting dates. I have three date variables (daily_case_date…
Subscribe to:
Post Comments (Atom)
0 Response to Problem with dropping observations in longitudinal study
Post a Comment