I'm working with a dataset for a project that has been runnning for a few years. We used MS ACCESS as the data collection tool. Each week, the data would be manually selected and copied to an SPSS file via the COPY/PASTE function. The file would be 'Saved As' with a new date, and the old version moved to an ARCHIVE folder. I'm cleaning data now, and notice that data values will randomly change, or cases will duplicate and overwrite the data of several other cases. i.e. Instead of having 250 different cases, I can suddenly have 30 of the same case, and 220 different cases.
Does anybody have any suggestion for what may be causing this?
------------------------------
Tegan Murray
------------------------------
#SPSSStatistics