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
regards
Jens Lauritsen
EpiData Association
hi
Has anyone figured out how to enter GPS coordinates in Epidata in a
form which preserves the structure so that they can be exported to
another program for analysis? Thanks in advance for any help,
Susie Foster
Dear Juergen (and all),
Thanks for your help.
I want the MEMID to be automatically created after MEMBERNO has been
entered. 4 variables will be entered, and the MEMID must be an
agreggation of these 3 variables. So this is how the chk file command
currently looks:
MEMBERNO
RANGE 0 99
MUSTENTER
AFTER ENTRY
LET
MEMID=String(LOCALITY)+String(VILLAGECOD)+String(HHOLDCODE)+String(MEMBERNO)
END
END
The MEMID must be 10 digits long, which means that the other
variables must be a certain length, and therefore 'keep their zeros'
at the beginning.
For example:
LOCALITY = 1 (must be 1 digit)
VILLAGECOD = 023 (must be 3 digits)
HHOLDCODE = 0014 (must be 4 digits)
MEMBERNO = 12 (must be 2 digits)
Juergen, I tried to include what you suggested within the brackets
but in this case, the MEMID simply didn't appear. This is how it looked:
MEMBERNO
RANGE 0 99
MUSTENTER
AFTER ENTRY
LET
MEMID=String(LOCALITY*1000000000)+String(VILLAGECOD*1000000)+String(HHOLDCODE*1000)+String(MEMBERNO)
END
END
Any ideas why this didn't work?
Your help is very much appreciated!
Thanks again,
Nicki
At 18:01 18/05/2009, you wrote:
>Send EpiData-list mailing list submissions to
> epidata-list(a)lists.umanitoba.ca
>
>To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>or, via email, send a message with subject or body 'help' to
> epidata-list-request(a)lists.umanitoba.ca
>
>You can reach the person managing the list at
> epidata-list-owner(a)lists.umanitoba.ca
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of EpiData-list digest..."
>
>
>EpiData-list mailing list
>___________________________________
>
>Today's Topics:
>
> 1. Consistency in number of digits (epidata-list(a)lists.umanitoba.ca)
> 2. Re: Consistency in number of digits
> (epidata-list(a)lists.umanitoba.ca)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Mon, 18 May 2009 14:28:12 +0100
>From: epidata-list(a)lists.umanitoba.ca
>Subject: [EpiData-list] Consistency in number of digits
>To: epidata-list(a)lists.umanitoba.ca
>Message-ID: <6.2.5.6.0.20090518141625.03381728(a)ucl.ac.uk>
>Content-Type: text/plain; charset="us-ascii"; format=flowed
>
>Dear All,
>
>I apologise if this question is simple but I really can't figure it out.
>
>In creating my chk file, I need to ensure that four of the variables
>contain a certain number of digits. I know this is normally
>controlled by number fields the .qes file. However, in this instance
>I need zeros to be included at the beginning (eg. 0003) so that all
>responses contain the same number of digits. This is because I will
>be putting these 4 variables together to create a 10 digit identifier
>later in the chk file.
>
>At the moment, whenever I enter 0003, the zeros are removed and I am
>left with just 3.
>
>Does anyone know if there is a way to ensure the zeros remain, and to
>ensure that each variable entered contains 4 digits?
>
>Many thanks in advance for your advice!
>
>Nicki
>
>
>Nicki Bailey
>Centre Administrator
>Leonard Cheshire Disability and Inclusive Development Centre
>Department of Epidemiology and Public Health
>University College London
>4 Taviton Street, London, WC1H 0BT, UK
>Tel: +44 (0) 207 679 5589
>Fax: +44 (0) 207 388 2291
>www.lcdisability.org/idc
>
>
>
>------------------------------
>
>Message: 2
>Date: Mon, 18 May 2009 16:05:12 +0200
>From: epidata-list(a)lists.umanitoba.ca
>Subject: Re: [EpiData-list] Consistency in number of digits
>To: epidata-list(a)lists.umanitoba.ca
>Message-ID: <4A116B18.2010104(a)fifas.de>
>Content-Type: text/plain; charset="iso-8859-1"
>
>Dear Nicki,
>
>how will your identifier look like? Why doesn`t it work like this?
>
>v1=2
>v2=105
>v3=27
>v4=7
>
>ident= v1*1000000000 + v2*1000000 + v3*1000 + v4 = 2105027007 (with 3
>digits/variable)
>
>Regards
>Juergen
>
>
>epidata-list(a)lists.umanitoba.ca schrieb:
> > Dear All,
> >
> > I apologise if this question is simple but I really can't figure it out.
> >
> > In creating my chk file, I need to ensure that four of the variables
> > contain a certain number of digits. I know this is normally controlled
> > by number fields the .qes file. However, in this instance I need zeros
> > to be included at the beginning (eg. 0003) so that all responses
> > contain the same number of digits. This is because I will be putting
> > these 4 variables together to create a 10 digit identifier later in
> > the chk file.
> >
> > At the moment, whenever I enter 0003, the zeros are removed and I am
> > left with just 3.
> >
> > Does anyone know if there is a way to ensure the zeros remain, and to
> > ensure that each variable entered contains 4 digits?
> >
> > Many thanks in advance for your advice!
> >
> > Nicki
> >
> >
> > Nicki Bailey
> > Centre Administrator
> > Leonard Cheshire Disability and Inclusive Development Centre
> > Department of Epidemiology and Public Health
> > University College London
> > 4 Taviton Street, London, WC1H 0BT, UK
> > Tel: +44 (0) 207 679 5589
> > Fax: +44 (0) 207 388 2291
> > www.lcdisability.org/idc
> > _______________________________________________
> > EpiData-list mailing list
> > EpiData-list(a)lists.umanitoba.ca
> > http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>--
>***********************************************************
>Freiburger Institut fuer angewandte Sozialwissenschaft e.V.
>FIFAS
>Erasmusstr. 16, D-79098 Freiburg
>Telefon: (0761) 28 83 64 Fax: (0761) 29 27 493
>Web: www.fifas.de
>E-Mail: info(a)fifas.de
>
>
Dear Nicki,
Just set the type of data to STRING,then "0" will not be ingored.You can connect several strings directly.so:
v1=2
v2=105
v3=27
v4=7
V5=v1+v2+v3+v4=2105277
note that v1-v5 are all strings! of course u can input "0" in the fields and they are all identified as strings. also you can try function string(), which can convert interger to string.
regards,
Justin
2009-05-19
alasiri17
发件人: epidata-list-request
发送时间: 2009-05-19 01:01:30
收件人: epidata-list
抄送:
主题: EpiData-list Digest, Vol 67, Issue 6
Send EpiData-list mailing list submissions to
epidata-list(a)lists.umanitoba.ca
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.umanitoba.ca/mailman/listinfo/epidata-list
or, via email, send a message with subject or body 'help' to
epidata-list-request(a)lists.umanitoba.ca
You can reach the person managing the list at
epidata-list-owner(a)lists.umanitoba.ca
When replying, please edit your Subject line so it is more specific
than "Re: Contents of EpiData-list digest..."
EpiData-list mailing list
___________________________________
Today's Topics:
1. Consistency in number of digits (epidata-list(a)lists.umanitoba.ca)
2. Re: Consistency in number of digits
(epidata-list(a)lists.umanitoba.ca)
----------------------------------------------------------------------
Message: 1
Date: Mon, 18 May 2009 14:28:12 +0100
From: epidata-list(a)lists.umanitoba.ca
Subject: [EpiData-list] Consistency in number of digits
To: epidata-list(a)lists.umanitoba.ca
Message-ID: <6.2.5.6.0.20090518141625.03381728(a)ucl.ac.uk>
Content-Type: text/plain; charset="us-ascii"; format=flowed
Dear All,
I apologise if this question is simple but I really can't figure it out.
In creating my chk file, I need to ensure that four of the variables
contain a certain number of digits. I know this is normally
controlled by number fields the .qes file. However, in this instance
I need zeros to be included at the beginning (eg. 0003) so that all
responses contain the same number of digits. This is because I will
be putting these 4 variables together to create a 10 digit identifier
later in the chk file.
At the moment, whenever I enter 0003, the zeros are removed and I am
left with just 3.
Does anyone know if there is a way to ensure the zeros remain, and to
ensure that each variable entered contains 4 digits?
Many thanks in advance for your advice!
Nicki
Nicki Bailey
Centre Administrator
Leonard Cheshire Disability and Inclusive Development Centre
Department of Epidemiology and Public Health
University College London
4 Taviton Street, London, WC1H 0BT, UK
Tel: +44 (0) 207 679 5589
Fax: +44 (0) 207 388 2291
www.lcdisability.org/idc
------------------------------
Message: 2
Date: Mon, 18 May 2009 16:05:12 +0200
From: epidata-list(a)lists.umanitoba.ca
Subject: Re: [EpiData-list] Consistency in number of digits
To: epidata-list(a)lists.umanitoba.ca
Message-ID: <4A116B18.2010104(a)fifas.de>
Content-Type: text/plain; charset="iso-8859-1"
Dear Nicki,
how will your identifier look like? Why doesn`t it work like this?
v1=2
v2=105
v3=27
v4=7
ident= v1*1000000000 + v2*1000000 + v3*1000 + v4 = 2105027007 (with 3
digits/variable)
Regards
Juergen
epidata-list(a)lists.umanitoba.ca schrieb:
> Dear All,
>
> I apologise if this question is simple but I really can't figure it out.
>
> In creating my chk file, I need to ensure that four of the variables
> contain a certain number of digits. I know this is normally controlled
> by number fields the .qes file. However, in this instance I need zeros
> to be included at the beginning (eg. 0003) so that all responses
> contain the same number of digits. This is because I will be putting
> these 4 variables together to create a 10 digit identifier later in
> the chk file.
>
> At the moment, whenever I enter 0003, the zeros are removed and I am
> left with just 3.
>
> Does anyone know if there is a way to ensure the zeros remain, and to
> ensure that each variable entered contains 4 digits?
>
> Many thanks in advance for your advice!
>
> Nicki
>
>
> Nicki Bailey
> Centre Administrator
> Leonard Cheshire Disability and Inclusive Development Centre
> Department of Epidemiology and Public Health
> University College London
> 4 Taviton Street, London, WC1H 0BT, UK
> Tel: +44 (0) 207 679 5589
> Fax: +44 (0) 207 388 2291
> www.lcdisability.org/idc
> _______________________________________________
> EpiData-list mailing list
> EpiData-list(a)lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
--
***********************************************************
Freiburger Institut fuer angewandte Sozialwissenschaft e.V.
FIFAS
Erasmusstr. 16, D-79098 Freiburg
Telefon: (0761) 28 83 64 Fax: (0761) 29 27 493
Web: www.fifas.de
E-Mail: info(a)fifas.de
-------------- next part --------------
A non-text attachment was scrubbed...
Name: info.vcf
Type: text/x-vcard
Size: 213 bytes
Desc: not available
Url : http://lists.umanitoba.ca/pipermail/epidata-list/attachments/20090518/15e5b…
------------------------------
________________________________________
EpiData-list(a)lists.umanitoba.ca
http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 67, Issue 6
*******************************************
Dear All,
I apologise if this question is simple but I really can't figure it out.
In creating my chk file, I need to ensure that four of the variables
contain a certain number of digits. I know this is normally
controlled by number fields the .qes file. However, in this instance
I need zeros to be included at the beginning (eg. 0003) so that all
responses contain the same number of digits. This is because I will
be putting these 4 variables together to create a 10 digit identifier
later in the chk file.
At the moment, whenever I enter 0003, the zeros are removed and I am
left with just 3.
Does anyone know if there is a way to ensure the zeros remain, and to
ensure that each variable entered contains 4 digits?
Many thanks in advance for your advice!
Nicki
Nicki Bailey
Centre Administrator
Leonard Cheshire Disability and Inclusive Development Centre
Department of Epidemiology and Public Health
University College London
4 Taviton Street, London, WC1H 0BT, UK
Tel: +44 (0) 207 679 5589
Fax: +44 (0) 207 388 2291
www.lcdisability.org/idc
Dear all,
I would have a question about the creation of an identifier for data entry.
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
Do you have any clue about how to do this?
Thank you for your help.
Jean-Francois
Hello
I use the command for copy the REC file,
AFTER FILE
BACKUP C: \ backup \ HPH
END
and it works very well.
But I need to add other directories in this BACKUP simultaneously (F: \
backup \ HPH) and (C: \ backup \ HPH )
How can I run this command twice? In the same CHK.
1 .- I tried:
AFTER FILE
BACKUP C: \ backup \ HPH
BACKUP F: \ backup \ HPH
END
It does not work (1 .-)
2 .- I tried
AFTER FILE
BACKUP C: \ backup \ HPH
END
AFTER FILE
BACKUP F: \ backup \ HPH
END
It does not work (2 .-)
How can I do? I appreciate your prompt response
Greetings,
I write from Chile South America
Carlos Ortega Areyte
Biostatistician
--
Carlos A. Ortega Areyte
Prof. de Matemática y Computación
Magíster en Bioestadística
Hi Jean-François
This is what is needed:
If you want the ID is generated automatically
Considers that your variables are string type
Q01 Région <A >
Q02 Village <A >
Q03 Household <A >
Q04 Member <A >
ID Identifiant <A >
in the chikfile
Paste:
Q01
RANGE 1 10
LEGAL
2
3
4
5
END
MUSTENTER
END
Q02
RANGE 1 30
LEGAL
2
3
4
5
6
7
8
9
10
END
MUSTENTER
END
Q03
RANGE 1 10
LEGAL
2
3
5
6
END
MUSTENTER
END
Q04
RANGE 1 7
LEGAL
2
3
4
5
6
7
END
MUSTENTER
AFTER ENTRY
LET ID=Q01+Q02+Q03+Q04
END
END
ID
NOENTER
END
Put the "Range" if you think putting Number, but it is not worth
Thanks
__________________________
JP DIBY-KONAN, MD, MPH
Sous-Directeur de l'Information Sanitaire
Ministère de la Santé & Hygiène Publique
(+225) 05 994 326 / 02 724 162
(+225) 20 323 440
-------Message original-------
De : epidata-list-request(a)lists.umanitoba.ca
Date : 16/05/2009 02:02:36
A : epidata-list(a)lists.umanitoba.ca
Sujet : EpiData-list Digest, Vol 67, Issue 3
Send EpiData-list mailing list submissions to
epidata-list(a)lists.umanitoba.ca
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.umanitoba.ca/mailman/listinfo/epidata-list
or, via email, send a message with subject or body 'help' to
epidata-list-request(a)lists.umanitoba.ca
You can reach the person managing the list at
epidata-list-owner(a)lists.umanitoba.ca
When replying, please edit your Subject line so it is more specific
than "Re: Contents of EpiData-list digest..."
EpiData-list mailing list
___________________________________
Today's Topics:
1. creating an identifiant from various variables
(epidata-list(a)lists.umanitoba.ca)
----------------------------------------------------------------------
Message: 1
Date: Fri, 15 May 2009 17:38:04 +0100
From: epidata-list(a)lists.umanitoba.ca
Subject: [EpiData-list] creating an identifiant from various variables
To: epidata-list(a)lists.umanitoba.ca
Message-ID: <6.2.5.6.0.20090515173330.035cdd18(a)ucl.ac.uk>
Content-Type: text/plain; charset="us-ascii"; format=flowed
Dear all,
I would have a question about the creation of an identifier for data entry.
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
Do you have any clue about how to do this?
Thank you for your help.
Jean-Francois
------------------------------
________________________________________
EpiData-list(a)lists.umanitoba.ca
http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 67, Issue 3
*******************************************
Even in using dataentry for many applications, I never had this problem
before:
the new database has a "base.rec" with basic informations about a unit
and connected with "relate" a file with 25 lines, all similar (only the
var names changes) describing actions through a code . The line consists
of date, actions and a small comment-field. The actions are numeric and
the label appears when typed with the "type" command. One unit can have
more than one of this actions sheet; when a sheet is full the user
starts a new one.
Till here there is no problem.
---- action file ----
id ____ jenr aujourd'hui <Today-dmy>
jcd01 <dd/mm/yyyy> jca01 ## jcm01 ________________
jcd02 <dd/mm/yyyy> jca02 ## jcm02 ________________
jcd03 <dd/mm/yyyy> jca03 ## jcm03 ________________
------
The problem appears only - what happens daily - when the user has to
add one or two "action-codes" for one unit, than has to change to
another unit and add new actions for another unit and of course on an
other actions-sheet. At that moment the action labels from the first
sheet appears also on your screen and theses comments are usually wrong.
So I want to add a "clear comment legal all" command in the before
record block of the corresponding chk-file but that is not possible. Is
there another method to get to the same result ?
regards
Casta