I am working with several very large data sets (314,000+cases each). I need one of the variables to be copied and pasted into a new variable. However, this new variable needs to be offset from the 1st by one case/row. For example, if variable 1, case 1 has a value of 13, I want variable 2 case 1 to be blank and variable 2, case 2 to be 13.
I've encountered several problems:
1.) If I highlight the entire variable by clicking the variable name, copy, then paste, I have the identical variable, but cannot just insert a cell in order to offset variable 2 from variable one (like I can in Excel).
2.) If I highlight case one in the column and scroll down to the end of the column and Shift + click the last cell, the computer will copy, but not paste the data. If my computer doesn't freeze in the pasting process, it will only paste the first 81 of my values and leave the rest of the cases blank.
3.) I've tried copying anywhere between 2500-10,000 rows at a time and the computer will copy and paste only some of the values. My first hundred+ values are correct, but then I'll have random zeros placed in several cases. Then, once again, it will have normal values for a while followed by zeros again.
4.) The largest amount of cases I've been able to successfully copy and paste without any issue has been appx 1500. This is a HUGE problem given my data size.
Thus far, my only solution has been to open the same data into a new SPSS sheet, delete all unnecessary rows, shift the one I need down one row and then copy and paste it into the original document.
This works, but it seems like SPSS shouldn't have such a huge copy and paste problem to begin with. Am I missing something?