Tools to Direct Change Duplicate ID Number
Posted: April 4th, 2017, 1:30 pm
Dear Master
Does any tool to change the duplicate case ID number ? so later when its done, I can open this concatenated file without error message (duplicate ID/index).
This is my situation :
I have merge many files with Concatenate tools, with option "concatenate regardless file structure." I did not use the dictionary for check the duplicate because this will take much time, as I realized that the files I merge has many duplicate id.
File to merge: file1.dat, file2.dat, file3.dat, file4.dat, file5.dat, file6.dat, file7.dat, file8.dat, file9.dat, file10.dat, .... file20.dat
Output: All_Concatenated.dat
Right now I use Index File tools to check the duplicate ID in All_Concatenated.dat, but can not make direct change of duplicate ID.
I have to choice which case, write down the the other/s one, or leave them, then do the change the ID on file1.dat or file2.dat ...that will take a long time
So usually, I take the other way that more easy for me: I convert this All_Concatenated.dat to SPSS and make the change the duplicate ID in SPSS.
But, on this step, I can not back to CSPro data entry mode as file has been on SPSS format.
So perhaps if any tools that able to change duplicate ID Number directly ? So my All_Concatenated.dat would clean and can open without error/index id duplicate message anymore.
Please advice, master. Josh, George .
Many Thanks
Yanina
Does any tool to change the duplicate case ID number ? so later when its done, I can open this concatenated file without error message (duplicate ID/index).
This is my situation :
I have merge many files with Concatenate tools, with option "concatenate regardless file structure." I did not use the dictionary for check the duplicate because this will take much time, as I realized that the files I merge has many duplicate id.
File to merge: file1.dat, file2.dat, file3.dat, file4.dat, file5.dat, file6.dat, file7.dat, file8.dat, file9.dat, file10.dat, .... file20.dat
Output: All_Concatenated.dat
Right now I use Index File tools to check the duplicate ID in All_Concatenated.dat, but can not make direct change of duplicate ID.
I have to choice which case, write down the the other/s one, or leave them, then do the change the ID on file1.dat or file2.dat ...that will take a long time
So usually, I take the other way that more easy for me: I convert this All_Concatenated.dat to SPSS and make the change the duplicate ID in SPSS.
But, on this step, I can not back to CSPro data entry mode as file has been on SPSS format.
So perhaps if any tools that able to change duplicate ID Number directly ? So my All_Concatenated.dat would clean and can open without error/index id duplicate message anymore.
Please advice, master. Josh, George .
Many Thanks
Yanina