BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

Wednesday, March 3, 2021

Dropping duplicates takes more that 24 hr.

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

BJ Data Tech Solution

Wednesday, March 3, 2021

Dropping duplicates takes more that 24 hr.

No comments:

Post a Comment