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
mata mlib createI'm having trouble with mata mlib create . I can't see to get a mata library set up anywhere …
Changes in Control/Treatment groups after PSMDear friends, Hi. As in the previous post, Hi All, In case anyone viewing this thread is inte…
Panel Data Regression and ANOVAHi, I am using panel data for US manufacturing companies for the period 2000-19. I am focusing on t…
Find value starting with a pattern ( similar to LIKE operator in SQL)Hello ALL, I am new to Stata, I have a small doubt, Any Help would be greatly appreciated. TABLE1(…
Between subjects error term for three-way repeated measures anovaI have been having some difficulties trying to run a three-way, repeated measures anova. I have made…
Subscribe to:
Post Comments (Atom)
0 Response to Drop duplicates depending on two variables
Post a Comment