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
Average Marginal Effects - Recursive Bivariate ProbitDear Statalisters, I would like to calculate the average marginal effects from a recursive bivariate…
Twoway Kdensity Plot – Truncate X-AxisDear Statalisters, I am using Stata 15.1 MP on a Windows 10 PC and face the following problem: I wa…
n and % for a series of binary variablesHi. I woud like to produce n and % for a series of binary variables in the same table. For example,…
Change vartypeHello, I have a dataset I have created myself from Excel, which is made mostly out of percentages an…
How to correct autocorrelation in a multiple regression?Hello everyone on statalist! Hope you had a great weekend. I am working on a project and have run i…
Subscribe to:
Post Comments (Atom)
0 Response to Drop duplicates depending on two variables
Post a Comment