SPSS Statistics

Expand all | Collapse all

Issue with SPSS Duplicating and Replacing Lines of Data

  • 1.  Issue with SPSS Duplicating and Replacing Lines of Data

    Posted Wed August 05, 2020 09:51 AM
    Hello, I'm using SPSS on my Windows PC at work. I've had this issue come up twice where some lines of data will be duplicated and will replace other lines of data. For example, we have 107 study subjects, and subject #1's data will duplicate and replace the data for 3-4 subjects. This is a difficult error to catch, as the database will show that it still has 107 lines of data correlating with our 107 subjects. This happened once when I was using SPSS 26 and happened again recently with SPSS 27. I believe it's happened after sorting cases and saving. I was not analyzing any data in both instances, only editing certain cells. Has anyone had this happen before? Could I be doing something wrong that is causing this? Any insight as to how to prevent/fix this is greatly appreciated.

    ------------------------------
    Vida Sadeghi
    ------------------------------


  • 2.  RE: Issue with SPSS Duplicating and Replacing Lines of Data

    Posted Wed August 05, 2020 12:48 PM
    I infer that you were editing data using the Data Editor Data View.  The only thing I can think of is that you might have accidentally copied and pasted a case in the process.
    If the IDs are sequential numbers or some other regular pattern or you can count on uniqueness, you could run a check after an editing session to see if the IDs violate the pattern.

    ------------------------------
    Jon Peck
    ------------------------------