- EpiData-list - University of Manitoba Mailing Lists

creating an identifiant from various variables + double data entry
by epidata-list＠lists.umanitoba.ca 10 Jul '09

10 Jul '09

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

1 6

Is it possible to link the follow-up to the baseline using EpiData?
by epidata-list＠lists.umanitoba.ca 30 Jun '09

30 Jun '09

Dear all, I have a question about linking the follow-up round of a survey to the baseline which was data entered using EpiData. The follow-up is a new database that will be linked to the baseline during analysis. During data entry, I want to make sure that the IDs entered in the follow-up match those from the baseline in the household roster of the survey. No member that was in the household in the baseline should be missing, however new members can be added to the household. I have villageid, householdid, and personid, each of which is entered separately. I can then create a unique id which combines these to ID the unique individual. The baseline data was entered using double data entry where the data was compared dynamically (Menu Option: "Double Entry verification") and the follow-up will be done in the same manner. The survey is large and the data are entered on several different computers that are not networked. The only way I can think of to link the follow-up to the baseline in order to compare the IDs would be to do a mini double data entry after the first data entry of the household roster where I check only the IDs for the data and see what is in the follow-up that isn't in the baseline, but this seems like a poor solution. I would prefer to do something dynamic, which 1) doesn't allow the data entry clerk to move on to another household until they have entered all of the IDs from the baseline and 2) flashes a warning if there is an ID entered that does not match with the baseline. I don't think that EpiData has these capabilities. Please let me know if I am simply not educated enough in this software. Thank you for your help (and I apologize for this long posting). Emilie

1 3

Changed principles for passwords
by epidata-list＠lists.umanitoba.ca 29 Jun '09

29 Jun '09

Dear All Due to several requests the list will from now on send password reminders from time to time. You can go into the list specification and turn this on (after you receive the first reminder). It would be constructive for the development of the Core module if users could find some time to challenge the core-module-test application in Linux or Windows. See www.epidata.dk/testing.php Report success and/or failures to the list. regards Jens Lauritsen EpiData Association

1 6

Re: EpiData-list Digest, Vol 68, Issue 5
by epidata-list＠lists.umanitoba.ca 28 Jun '09

28 Jun '09

Jose, Well, I would say that You could use a softaware such as stattransfer which would solve this problem. If you dotnt have it, I would recomend any other statistical software is usually able to do so. I usually work with stata or R. With stata you may save he spreadsheet as csv or tb separeted and import within stata and save in stata format. With R is even more simple because thereis some packages that are able to import directly from xls and then save it in stata format or dbf format. Usually stata format is the most friendly for epidata entry. If you dont have any experience with R, perhaps you will find easier to use a grphical interface such as Rcmdr or pmg. To install the Rcmdr and use R with a graphical interface, after installing it type "install.packeges("Rcmdr")" and afer the install type "library("Rcmdr")" The rest should be more intuitive! Abraço forte e que a força esteja com você, Pedro Emmanuel

1 0

Excel 2007
by epidata-list＠lists.umanitoba.ca 28 Jun '09

28 Jun '09

Dear member in the group is there any way to export data from Excel 2007 that can be read with Epidata. I have found the excel 2007 does not export to dbf format. I will appreciate any help. Jose Arturo Dr. Jose Arturo Farfan Ale Centro de Investigaciones Regionales "Dr. Hideyo Noguchi" Universidad Autónoma de Yucatán Av. Itzáes por 59, num. 490 Mérida, Yucatán, México 97000 Tel: (999) 923-22-74 (999) 924-57-55 Fax: (999) 923-61-20

1 2

EpiData Core Module - update
by epidata-list＠lists.umanitoba.ca 17 Jun '09

17 Jun '09

1 0

GPS data format in EpiData?
by epidata-list＠lists.umanitoba.ca 02 Jun '09

02 Jun '09

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

1 2

Re: EpiData-list Digest, Vol 67, Issue 6
by epidata-list＠lists.umanitoba.ca 20 May '09

20 May '09

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 > >

1 3

Re: EpiData-list Digest, Vol 67, Issue 6
by epidata-list＠lists.umanitoba.ca 18 May '09

18 May '09

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 *******************************************

1 0

Consistency in number of digits
by epidata-list＠lists.umanitoba.ca 18 May '09

18 May '09

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

1 3