SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only
Back to discussions
Expand all | Collapse all

How to select all duplicate records, whether 2 or 3 or more.

  • 1.  How to select all duplicate records, whether 2 or 3 or more.

    Posted Mon January 10, 2022 07:25 PM

    I have 545 records that have at least one duplicate entry as shown in the RespondentID. I need to see all entries of any RespondentIDs that are duplicated.

    Unfortunately, the identify duplicates flags only a single instance of the duplicate. My work-around hasn't worked.






    #SPSSStatistics
    #Support
    #SupportMigration


  • 2.  RE: How to select all duplicate records, whether 2 or 3 or more.

    Posted Mon January 10, 2022 09:32 PM

    If you are using Data > Identify Duplicate Cases and create a matchsequence variable, all the cases in the set of duplicates for a given id will have a number greater than zero. Does that help?






    #SPSSStatistics
    #Support
    #SupportMigration


Related Content