Dear ALL
I have set my ID as an auto-increment variable. During data entry i reached a point i stopped say at 1000 (may be questionnaire have some errors). I then jumped to start at 1500 and the CAPI worked fine with auto-increment. But when i return to 1001, auto-increment remembers the highest number entered. I have tried to restart the CAPI but still does not work. What can i do for auto-increment to work for this rage of 1001 to 1449????
AUTO INCREMENT PROBLEM
Forum rules
New release: CSPro 8.0
New release: CSPro 8.0
Re: AUTO INCREMENT PROBLEM
Auto increment always uses the highest value in the entire data file plus one. It does not fill in gaps. You would need to delete the cases above 1000 to get the next auto increment value to be 1001. You could make a copy of the data file, delete the cases above 1000 in the original file and continue data entry in that file. Then in the copy of the original file, delete the cases below 1001. When you are done with data entry you could then concatenate the two files together.
Another option is turn off auto-increment and enter the values manually.
Another option is turn off auto-increment and enter the values manually.