Dear stata forum,
I am quite new to Stata and I ran into an issue. I have panel data with quarterly observations from 1965 until 2020 for all US firms included in Compustat.
I want to drop the duplicates by using the following command:
duplicates drop gvkey Year_Quarter, force
However, Stata is working for 24 hours now and nothing happens. Is there a different way to find all the duplicates an remove them from the sample, a faster way?
best regards
Related Posts with Dropping duplicates takes more that 24 hr.
Computing Standard Deviation of annual returns over three years.Hello everyone, For my Replication Study, I am replicating a study for which I need the variable 'R…
Categorizing Patients by Diagnosis CodesHi, I have patient-level data with diagnosis codes. I need to use the category of diagnosis codes as…
forval returning error stating ambiguous abbreviation for variables b_01 and b_11I have a set of variables labelled b_01, b_02, b_03.....b_11, b_12, ....b_20 and similarly another s…
Create a dummy variable that equals 1 if the compensation committee is comprised wholly of independent directorsHi everyone, I am new to the stata forum and I have some questions. To run my regression, I need som…
split, parse(,) maximum number of variables reachedDear all, I'm using Stata 15 and trying to split a string variable into different component which ar…
Subscribe to:
Post Comments (Atom)
0 Response to Dropping duplicates takes more that 24 hr.
Post a Comment