Original Message:
Sent: Fri March 15, 2024 01:00 AM
From: Zeynep Ertekin
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Hello,
I am experiencing the same issue with password-protected data. The cases duplicate randomly when I enter a new variable or sometimes it changes the values of the other variables (such as dates). So far, this occurs with sorted data (based on ID numbers or dates) when I enter values either manually or copy-paste into a new variable.
I am using Windows 11, 64-bit, and SPSS 29.0.
I will try to work on non-Encrypthope data as you suggested above. I hope a solution is found soon because this is so frustrating and I don't even want to contemplate the scenario of not realizing this mistake:(
Thank you so much,
------------------------------
Zeynep Ertekin
Original Message:
Sent: Tue March 12, 2024 05:17 PM
From: Curtis Browning
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
@Katherine Brown Sorry you're seeing this problem.
- May I ask please if you are seeing it with a password-protected file?
- Are you using Windows or MacOS?
I have re-emphasized this defect for examination and fixing in the next release.
Thanks and regards,
------------------------------
Curtis Browning
SPSS Statistics Architect
Original Message:
Sent: Tue March 12, 2024 04:14 PM
From: Katherine Brown
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
We also recently started having this issue in SPSS 20.0 Version 29.0.2.0 (20) I had hoped the patch would fix the issue. I do think I got to recreate the issue in a non-password protected file. Before it would only replace the cases with a duplicate random case when we were sorting ascending and descending, but we were adjusting value labels and then noticed that it has created a duplicate. It always starts with duplicating the first case in our data but will randomly pick a case from the others to duplicate.
------------------------------
Katherine Brown
Original Message:
Sent: Wed May 10, 2023 12:34 PM
From: Curtis Browning
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Hi Elina,
Unfortunately this is a subtle timing-related issue and a solution has not been found yet. The information you supplied here is helpful however and confirms that thus far we have only seen this problem with password-protected files.
Therefore a work-around for this issue until a fix has been delivered: If you need to perform extensive editing in the data editor with a password-protected .sav file, first save it into a non-protected file, perform the edits, then save back into the original password-encrypted file, making sure to delete the temporary .sav file when finished. I know this is a sub-optimal solution, but hopefully it will enable you to make the edits you need to move ahead with your work.
Best regards,
------------------------------
Curtis Browning
SPSS Statistics Architect
Original Message:
Sent: Wed May 10, 2023 03:25 AM
From: Elina Oksanen
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Hello,
I have also had this issue for a while. I am using the 26.0.0.0 version on Windows at work. My document is password protected.
Today the issue occured again:
1. I created two new variants in between existing variants in variable view, named them and filled the columns by hand (not copy-paste) with data in data view.
2. I saved my document and noticed the issue had occured. It seemed like the overwritten lines had nothing in common, except the new copies were from the first 6 lines. There may have been 8 overwritten lines in my table of 36 rows, but I'm not sure. I noticed that the new variants I had added had not all been overwritten on the otherwise overwritten rows.
3. Luckily I already had had this issue for a few times and had backup versions of my document. I was able to copy-paste information (ctrl+c ctrl+v), but in two parts: columns before the new variants and after the new variants.
4. As I pasted the information before/to the left of the new variant columns, the new data on these new columns was also overwritten by the same rows, that SPSS had copied (eg. I was correcting a row that had been overwritten by row 2 and the new corrrect data in the new columns was then overwritten by the new data on row 2)
5. When I pasted the latter part, no new issues occured.
I have also had this issue but the rows SPSS copies move a column or two to the right. As I have columns that are defined strings, dates or numbers, you see how this messes up the table completely and I end up with cells filled with mixed symbols, such as @, ?, &,  and letters or numbers.
Has a solution already been found? If not, I hope this helps in the process.
------------------------------
Elina Oksanen
Original Message:
Sent: Wed March 15, 2023 10:09 AM
From: Rick Marcantonio
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Thank you, Heather.
One clue is that the data files showing this problem are password-protected. At least, we think that is a necessary condition. Can you tell me, has that been your experience as well?
------------------------------
Rick Marcantonio
Quality Assurance
IBM
Original Message:
Sent: Tue March 14, 2023 02:42 PM
From: Heather Brittain
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Hello,
We have been dealing with this frustrating issue since 2020 and came across this thread today. Following the instructions outlined above by Ryan Bentham, we were able to replicate the problem using SPSS v28.0.1.1 on Windows 7 enterprise, 64 bit OS. We also replicated this with numeric variables.
Rick Marcantonio, we appreciate that IBM is looking into this critical problem.
Warm regards,
------------------------------
Heather Brittain
Original Message:
Sent: Thu February 23, 2023 09:46 AM
From: Rick Marcantonio
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Thanks, Ryan.
We're looking at it right now.
------------------------------
Rick Marcantonio
Quality Assurance
IBM
Original Message:
Sent: Wed February 22, 2023 11:16 PM
From: Ryan Bentham
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Hi Rick,
Thanks for the update.
After a lot of mucking about, I have been able to reproduce the issue by copying and pasting (using the keyboard) when a .sav file is encrypted with a password. I am using version 29.0.0.0 (241). Another user mentioned the had the same issue occur when they were typing into the cell (not copy and paste) but I have not been able to reproduce that issue reliably. If I remove the password from the file, I cannot get the issue to occur.
I can reproduce the issue using these steps, and I have attached a recording showing the issue happening just in case.
- Open the attached data file (Test Data.sav) using the password password
- Click in to the cell in the third row of the VAR00003 column
- NOTE: row three VAR00001 = 10003; row four VAR00001 = 10004;
- Type in anything (e.g. Blah) and push Enter
- Push the up arrow to select the previous cell
- Copy the text using CTRL + C
- Push the down arrow to select the next cell
- Paste the text using CTRL + P
ERROR:
Row four now contains the data from row 1 (e.g., 10001 and 60).
Hopefully, following these steps will allow you to reproduce the error. We have removed SPSS encryption from this file in the meantime and will monitor if we continue to have this issue.
------------------------------
Ryan Bentham
Original Message:
Sent: Wed February 22, 2023 10:26 AM
From: Rick Marcantonio
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Hi. No one here is doubting that it happens. The problem is that we have not yet been able to find a replication scenario.
------------------------------
Rick Marcantonio
Quality Assurance
IBM
Original Message:
Sent: Tue February 21, 2023 10:42 PM
From: Ryan Bentham
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Hi
We have started to experience the same issue where we end up with duplicate rows overwriting existing rows. It seems to have happened after copying and pasting and also after editing a cell. We are only working on one data file (or copies of it) at the moment so can't say if it is happening with other files.
Before I spend a lot of time trying to troubleshoot and reproduce, I thought I would check to see if there is any update on this issue?
Many thanks
Ryan
------------------------------
Ryan Bentham
Original Message:
Sent: Tue August 23, 2022 02:52 PM
From: Curtis Browning
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
That does help Sanne, thanks for the above information. I have added it to the defect report that we have on this issue.
Best,
------------------------------
Curtis Browning
SPSS Statistics Architect
Original Message:
Sent: Tue August 23, 2022 09:03 AM
From: Sanne van Dijk
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Dear Curtis,
Thank you for your response. I agree with you: it is tricky. I tried to answer your questions as completely as possible:
1. Windows 10 Pro.
2. I manually added variables for which I filled in the values in single cells A) manually and B) by copy-pasting via the clipboard, indeed. I did not copy complete rows of data.
3. I did not sort the data while I was working on cleaning the data.
I hope that these answers are helpful.
Kind regards,
Sanne van Dijk
Sanne van Dijk MSc BA
PhD candidate Health Technology & Services Research group
University of Twente ï Faculty of Behavioural, Management & Social Sciences (BMS) ï www.utwente.nl/bms/htsr
Technical Medical Centre (Technohal), room 3106 ï visiting address: Hallenweg 5 ï 7522 NH Enschede
Telephone: +31 (0)53 489 8866 ï E-mail: s.h.b.vandijk@utwente.nl
Post office box 217 ï 7500 AE Enschede ï Office hours: Monday - Friday 08h30 -17h15
Original Message:
Sent: 8/22/2022 1:02:00 PM
From: Curtis Browning
Subject: RE: Issue with SPSS Duplicating and Replacing Lines of Data
Hi @Sanne van Dijk. Sorry to hear that you're experiencing problems with the Data Editor. Can you share a bit more information please?
1. Are you running on MacOS or Windows?
2. What actions are you doing in the Data Editor when the problem occurs? Did you use the clipboard to copy rows of data, were you editing a single cell, etc.
3. Had you recently sorted the data before the problem appeared?
Thanks - again apologies for the problem, but this is a tricky one and we're still dedicated to discovering and resolving the problem.
------------------------------
Curtis Browning
SPSS Statistics Architect
Original Message:
Sent: Fri August 19, 2022 04:27 AM
From: Sanne van Dijk
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
Hi. I am having exactly the same problem as you describe, using SPSS version 28.0.1.0. While editing data in the data view, suddenly one line of data duplicates and overwrites another line. The total number of lines keep the same. I was just trying some things, so I used only a part of my original dataset with 5 datalines and actually saw it happen in front of me. As I was just editing manually, I cannot provide any reproducible paths to let it happen. The only way I can think of is videorecording my screen as I am editing and "hoping" for it to happen, so others can see it too. I'm afraid I don't trust using SPSS for my data anymore, as this now happened a few times, using different datasets.
------------------------------
Sanne van Dijk
Original Message:
Sent: Tue August 04, 2020 06:07 PM
From: Vida Sadeghi
Subject: Issue with SPSS Duplicating and Replacing Lines of Data
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
------------------------------
#SPSSStatistics