- EpiData-list - University of Manitoba Mailing Lists

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

creating an identifiant from various variables
by epidata-list＠lists.umanitoba.ca 16 May '09

16 May '09

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

1 5

Backup Command working twice ...
by epidata-list＠lists.umanitoba.ca 16 May '09

16 May '09

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

1 2

Réf. : EpiData-list Digest, Vol 67, Issue 3
by epidata-list＠lists.umanitoba.ca 16 May '09

16 May '09

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

1 0

clearing all "legal comments" in data-entry before starting
by epidata-list＠lists.umanitoba.ca 06 May '09

06 May '09

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

1 1

Re: EpiData-list Digest, Vol 66, Issue 5
by epidata-list＠lists.umanitoba.ca 30 Apr '09

30 Apr '09

Jamie, Thank you for the chk code... it works perfectly. Very nice indeed. Best regards, Abraço forte e que a força esteja com você, Pedro Emmanuel

1 3

Retreiving a string
by epidata-list＠lists.umanitoba.ca 14 Apr '09

14 Apr '09

Epidata friends, I just spend almost the whole day trying to fix some typing errors. Nothing more than usual before starting some analysis. However It came to my attention that having just one key field maybe a lot misleading. Lets say that there a key id field called number in qes. v1 number ######### if the one who is typing types the worng number lets say 231022009 instead of 221022009 later this error may cause a lot of confusion and lead to other errors. The point is that this particular sort of error is hard to find and locate because this is the one field by which we should locate the record (the link to the CRF). Looking for the record by other fields is very fustrating unless the record has some very unusual data, such as age 99. How many records I would have with age 99?? Most likeli very few. One field that very often hleps is the patient intials, although it has very few letters, very unlikeli there is more than 3 or 4 in every thousand records with the same initials. Therefore I ask to you guys if there is a way in the chk file to retrieve from the name the initials of the full name. v1 number ######### v2 name: <A > v3 initials: <A > The objetictive is: v2 name: JENS LAURISTEN v3 initials: JL v2 name: PEDRO EMMANUEL AMERICANO DO BRASIL v3 initials PEADB Telling the typer to type this is an option, but Is it possible stick this magic in the chk file? I looked in the string functions from Epidata documentation but didnt find anything that could make a way around! Best regards? Abraço forte e que a força esteja com você, Pedro Emmanuel

1 1