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
    ------------------------------



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

    Posted Tue July 06, 2021 01:27 PM
    Hello!
    I have exactly the same problem. I'm using SPSS 27 and when editing data in the SPSS editor, SPSS quite regularly replaces random lines of data with duplicates of other cases. And I did not copy/paste whole lines of data, so this is definitely not a "manual mistake".
    So far, this has only occurred when I'm working on a specific dataset. Could there be a problem with the file?
    Thanks in advance!

    ------------------------------
    Gerhard Rocholl
    ------------------------------



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

    Posted yesterday
    Edited by Curtis Browning yesterday
    We believe this has been fixed in version 28.0.0 as it cannot be reproduced in-house with that version of Statistics. Before closing this issue we would like to see if any users have seen this problem with version 28? Please reply here or privately with any experiences with this issue using v28.

    @Vida Sadeghi, @Gerhard Rocholl, @Keeley Dobinson

    Thank you,
    ------------------------------
    Curtis Browning
    SPSS Statistics Architect
    ------------------------------



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

    Posted Tue July 06, 2021 09:44 AM
    I have exactly the same problem. ​When editing data in the SPSS 27 editor, SPSS randomly duplicates lines of data and overwrites existing data. So far, this has only occurred with one particular dataset. Could there be a problem with the file? I have not copy/pasted complete lines of data myself, so I definitely did not create these duplicates myself.  
    Thanks in advance for any advice!

    ------------------------------
    Gerhard Rocholl
    ------------------------------



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

    Posted 29 days ago
    Hello there

    Please may I ask if you managed to find out what was causing this problem? I am experiencing the same issue working with a large dataset in SPSS 27 and it is causing lots of stress and frustration!

    Any advice you are able to offer would be hugely appreicated!

    ------------------------------
    Keeley Dobinson
    ------------------------------



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

    Posted Wed July 07, 2021 08:25 AM
    Hi Gerhard,

    If you are able to send me a copy of the data file that is resulting in duplicated cases, along with the steps you are taking when cases are duplicated, I will be happy to take a look at it and get back to you with my findings.

    Best,
    Curtis Browning

    ------------------------------
    Curtis Browning
    SPSS Statistics Architect
    ------------------------------