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-duplicate-observations-in-stata/ 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-introductory-econometrics-books/ 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.