[EpiData-list] creating an identifiant from various variables + double data entry

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Tue May 26 05:01:00 CDT 2009

Dear Jens,

Thanks for your helpful comment on creating an identifiant from various
variables and double data entry (see below).

I just wanted to clarify a few things:

1) Does this mean that when using the 'Double Entry Verification' option
(immediate comparison), this will not work if you have added any new
variables into the .rec, or changed the order of the variables from the
existing .rec?

2) If you use the other method of data verification (entering data into
two seperate files and then validating duplicate files afterwards), is it
possible to compare the old and new .rec files, even if a new variable has
been added, or the order of the variables has been changed?

Will using the 'validate duplicate files' option work if the new .rec file
has the variables in a different order?

Thanks so much for all your help,

Nicki Bailey

One aspect of this about unique identifiers is when users want to do
double entry.

The only double entry option in this situation is to enter the data
twice and then compare afterwards, since the "immediate comparison"
double entry mode is not available for combined field unique entries
unless the records are entered in EXACTLY the same sequence as the first
time. The problem for the user is, that the system is NOT giving correct
warnings in the immediate double entry if the unique index is created in
contrast to entered directly.
> I would like the identifier to be automatically created in the .rec
> file after entering 4 variables and as an aggregation of these 4
> variables.
> For instance my identifier is
> ID=region number+village number+household number+member in the
> household number

Jens Lauritsen
EpiData Association

More information about the EpiData-list mailing list