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