How to delete duplicate observations in Stata | Stata Tutorial
In this video, we learn how to drop/delete duplicate observations in stata. We also see how do we report duplicate observations and list them. And at the end of the video, we learn how to tag duplicate observations.
We normally have to deal with this issue when we are going to xtset data in stata. We sometimes get an error "repeated time values within panel
r(451);". This error is because we have repeated observations.
Following link contains the files used in the video:
https://payhip.com/b/hykfP
Following link contains more information on this topic:
https://thedatahall.com/delete-drop-d...
00:00 Error repeated time values within panel
2:00 Report duplicate observations
5:45 List of all duplicates observations
6:10 Duplicates from each group
6:40 Duplicates with respect to all observations
7:10 Drop duplicates with respect to variables
8:30 Drop duplicates in just one group
9:15 Tag the duplicate observations
10:38 Drop duplicates based on a subset of data
Best 10 Introductory Econometrics Books
https://thedatahall.com/best-10-intro...
Introduction to Econometrics by Jeffrey M. Wooldridge
https://amzn.to/44ttv2z
Econometric Analysis by William H. Greene
https://amzn.to/3AOCE8j
Basic Econometrics by Damodar Gujarati and Dawn Porter
https://amzn.to/3APIGpf
A Guide to Econometrics by Peter Kennedy
https://amzn.to/44taOfI
Website: thedatahall.com
Disclaimer: Some links are affiliate links that help the channel at no cost to you.