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
Using data from multiple files (Excel)Hi everyone, I'm still taking my first steps in Stata. Still, I have quite a lot of data (simulated…
Meta forestplot and Meta summarizeDear Stata Users, I am working in a meta analysis of prior 20 studies. In several studies I have co…
Reshape Best to Worst datasetDear all, I turn to you for a second request for help linked to the question at the link: https://ww…
2020 Swiss Stata Conference takes place virtuallyDue to the development of the situation, the Swiss Stata Conference on November 19 will take place v…
Logit Confidence IntervalsHi, I was wondering whether someone could help me get less confused. I have run a logit model , whe…
Subscribe to:
Post Comments (Atom)
0 Response to Dropping duplicate observations conditioned on another variable
Post a Comment