Hi Everyone,
Thanks for taking the time to read my query.
I currently am cleaning a very big dataset (52 variables, 82284 observations) for longitudinal analysis. The dataset is based on information returned from 6 different surveys. I have converted the dataset to long format so currently there are about 6 different observations (in years) for each ID. There are approximately 13,000 unique ID variables.
In the third survey that was sent, additional information was asked that was not included in any further surveys but is essential to my analysis. I therefore want to exclude all participants who did not complete the third survey (in 2010).
What I am trying to find is some kind of command like this: drop id if Survey3Completed=. in 2001
Thank-you very much.
Sarah
Related Posts with Dropping observations based on multiple conditions
population distribution for stsplitI have a dataset where I calculated incidence by age groups using the following command: stset cens…
post doesn't post results successfullyHi Stata Users, I am using Stata 17 with the commands below to post results to file but for some re…
Variable creationHello everyone, In a paper I am writing for my studies, I want to recreate a proxy measuring earnin…
Summary statistics by countryDear all, I have the following dataset Code: * Example generated by -dataex-. To install: ssc ins…
Predict and margins after melogit with interactionsHello Statalisters, I am running a mixed effect model in Stata 15.1 using melogit, with weights. I n…
Subscribe to:
Post Comments (Atom)
0 Response to Dropping observations based on multiple conditions
Post a Comment