Hi,
I am using Stata 16.1, and have the following (general) issue. I want to drop duplicate observations of one variable (educ) from my dataset but conditioned on another variable (year).
I've found an online dataset, such that it may be easier to talk about. First up I apologize that I am new Stata.
My problem: I want to drop all duplicates of educ for each corresponding year (72 & 74). This means I do not want educ's value to enter for year 72 if it's value has already been observed.
Here is what I've tried do to:
use http://fmwww.bc.edu/ec-p/data/wooldridge/fertil1
keep if year == 72 | year == 74
drop if educ == educ[_n-1] & (year == 72 | year == 74)
The problem:
I am not dropping all duplicates of educ
Any suggestions would be appreciated
Related Posts with Dropping duplicate observations conditioned on another variable
Predicted probabilities after biprobitHi everyone, I am using a biprobit model with two dichotomized outcome variables (health and mortali…
Difference-in-Difference - Collinearity ProblemHi all, I'm currently an undergraduate student and very new to STATA, I apologize for any "stupid" …
Should I include multiple year dummies in my difference-in-difference regression?Hi everyone. I am doing an analysis of the effects of access to school-based health centers (SBHCs) …
Latex-tabulate a combined matrix of coefficients and of t-statisticsI have many regressions (one per year, over 15 years) for 4 outcome variables. I have created 2 [15x…
question about reg a b c i.year, robusti have a question about this command reg a b c i.year, robust. what is the diffrence between using n…
Subscribe to:
Post Comments (Atom)
0 Response to Dropping duplicate observations conditioned on another variable
Post a Comment