Hi,
I am totally new to Stata (Version 17.0). I´ve got a data set icluding the variables ticker (some kind of ID Code for each company, ZOTS and ZY in the extract below) and anndats (announcement dates) as well as multiple other variables.
Now I need to drop all observations, where ticker and anndats are the same.
Here is an extract from list ticker anndats:
ZOTS 03nov2015
ZOTS 16feb2016
ZOTS 16feb2016
ZOTS 04may2016
ZOTS 04may2016
---------------------------
ZY 15nov2016
ZY 22feb2017
ZY 22feb2017
ZY 16may2017
Like, for example, i want to drop the third, the fifth and the eigth row, but keep the rest. How do I do that?
Related Posts with Drop duplicates depending on two variables
Structural approach with Poisson on panel data with endogenous regressorDear Statalists, for my thesis, I want to perform a Poisson IV with fixed effects on a panel data s…
year month dateHi all: i hope all of you have wonderful holidays!. I have a question about generating year-month da…
Variable order for interaction term in output table using esttabHello: I am trying to force two variables to show up at the very end of my regression table. My iss…
Matching 3 groups within a sample on industry and sizeHi, For my masters Accountancy I am doing a replication of the Johnson, Khurana and Reynolds (2002) …
Stata command for three interactions variables.Dear Statalist member, Good day everyone. I am using Stata 14.1. Here is the sample of my data. I a…
Subscribe to:
Post Comments (Atom)
0 Response to Drop duplicates depending on two variables
Post a Comment