- EpiData-list - University of Manitoba Mailing Lists

RE: EpiData-list Digest, Vol 55, Issue 2
by epidata-list＠lists.umanitoba.ca 03 May '08

03 May '08

Yes, in the "checks" option, click on Edit, Type in "Key Unique " - save and this will prevent duplicates from being entered. Sandy -----Original Message----- From: epidata-list-bounces(a)lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list-request(a)lists.umanitoba.ca Sent: 02 May 2008 07:02 PM To: epidata-list(a)lists.umanitoba.ca Subject: EpiData-list Digest, Vol 55, Issue 2 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. Adding unique number manually (epidata-list(a)lists.umanitoba.ca) 2. Re: Adding unique number manually (epidata-list(a)lists.umanitoba.ca) 3. Re: Adding unique number manually (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Fri, 2 May 2008 00:46:02 -0700 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Adding unique number manually To: epidata-list(a)lists.umanitoba.ca Message-ID: <897a5cf60805020046l1308e015s24557a2fd822b4f6(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Dear EpiData lister, thank you for your kind reply for my previous query. There is new question. Can I have variable for ID numbers, called id, and to make sure the value entered is unique to avoid duplicates during data entry? Thank you in advance and best regards ziad ------------------------------ Message: 2 Date: Fri, 02 May 2008 11:01:07 +0200 From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] Adding unique number manually To: epidata-list(a)lists.umanitoba.ca Message-ID: <481AD853.3080807(a)epiconcept.fr> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hello, When creating a questionnaire, in the field pick list, in the "other" tab, select ID auto number Alternatively in the questionnaire create a field with this specific field marker: <IDNUM> Example ID <IDNUM> Best regards Gilles Desve epidata-list(a)lists.umanitoba.ca a écrit : > Dear EpiData lister, thank you for your kind reply for my previous query. > > There is new question. > Can I have variable for ID numbers, called id, and to make sure the > value entered is unique to avoid duplicates during data entry? > > Thank you in advance and best regards > ziad > _______________________________________________ > EpiData-list mailing list > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > ------------------------------ Message: 3 Date: Fri, 2 May 2008 02:21:17 -0700 (PDT) From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] Adding unique number manually To: epidata-list(a)lists.umanitoba.ca Message-ID: <790215.97441.qm(a)web55315.mail.re4.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Hallo, Just use key unique command Caleb Ouma Ongong'a +254721-953790,020 356 2426 P.O Box 1984-00200 Nairobi-Kenya. Alternative e-mails oumacaleb(a)gmail.com caleb(a)dataworldresearch.com "Remember that happiness doesn't depend on what you are or on what you possess, but only on how you think."> --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 55, Issue 2 *******************************************

1 0

Adding unique number manually
by epidata-list＠lists.umanitoba.ca 02 May '08

02 May '08

Dear EpiData lister, thank you for your kind reply for my previous query. There is new question. Can I have variable for ID numbers, called id, and to make sure the value entered is unique to avoid duplicates during data entry? Thank you in advance and best regards ziad

1 2

Alyshia Landry is out of the office.
by epidata-list＠lists.umanitoba.ca 30 Apr '08

30 Apr '08

I will be out of the office starting 04/30/2008 and will not return until 05/01/2008. If you require immediate assistance, please contact Celina Sousa at extension 5300. Thanks and have a great day, Alyshia

1 0

Loosing data when reviewing the QES
by epidata-list＠lists.umanitoba.ca 29 Apr '08

29 Apr '08

Hi, all the answers that you have received are right. There is still one more reason why you can loose the data when trying to change the QES file. If you have used the option in EpiData to modify the name of the variables directly in the REC file (tools-->rename fields), then when you make a modification in the QES file no matter which way you use you will loose your data as the names of the variables in the REC file do not match the name of the variables in the QES. Hope it helps Pedro > -----Message d'origine----- > De : epidata-list(a)lists.umanitoba.ca > [mailto:epidata-list@lists.umanitoba.ca] Envoyé : lundi 28 avril 2008 > 13:13 > À : epidata-list(a)lists.umanitoba.ca > Objet : [EpiData-list] How to keep data when modifying questionnaire > > Hi, > i started data entry and now need to add 2 new variables to the QES > file, when i transfer the QES file into REC file, the old data > disappeared, any tips how to avoid it? > > Thank you in advance and best regards > ziad > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 54, Issue 13 > ********************************************

1 0

How to keep data when modifying questionnaire
by epidata-list＠lists.umanitoba.ca 29 Apr '08

29 Apr '08

Hi, i started data entry and now need to add 2 new variables to the QES file, when i transfer the QES file into REC file, the old data disappeared, any tips how to avoid it? Thank you in advance and best regards ziad

1 3

Res: EpiData-list Digest, Vol 54, Issue 12 -- adding new variables to a REC file
by epidata-list＠lists.umanitoba.ca 28 Apr '08

28 Apr '08

Hi, Ziad I think you can do it with menu TOOLS > REVISE DATA FILE You will have to enter values for these new variables on the yet entered questionaires, for sure. Hope it helps, Fúlvio Grups de Recerca d'Amèrica i Àfrica Llatines - UAB (Barcelona, Spain) Porto Alegre, Brazil ----- Mensagem original ---- De: "epidata-list-request(a)lists.umanitoba.ca" <epidata-list-request(a)lists.umanitoba.ca> Para: epidata-list(a)lists.umanitoba.ca Enviadas: Segunda-feira, 28 de Abril de 2008 19:09:21 Assunto: EpiData-list Digest, Vol 54, Issue 12 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. How to keep data when modifying questionnaire (epidata-list(a)lists.umanitoba.ca) Hi, i started data entry and now need to add 2 new variables to the QES file, when i transfer the QES file into REC file, the old data disappeared, any tips how to avoid it? Thank you in advance and best regards ziad ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/

1 0

Problems in EpiData Analysis test build 134 (browse and editor block)
by epidata-list＠lists.umanitoba.ca 25 Apr '08

25 Apr '08

EpiData Analysis build 134 I found problems with the internal definitions of variable names after running a browse in combination of running part of a pgm file in the editor in a block (F8). If you get strange "variable not found ....." or similar error and that variable is no longer in your dataset, unfortunetely you have to close analysis and start over. The error is either part of the editor NOT parsing lines correctly to analysis (e.g. the block is sent for analysis in a different size than shown on the screen) or the browser not cleaning up memory correctly after a browse. The error will be further documented, tracked and removed. I have NOT been able to create the error without using browse. - for safe mode showing of data in this build then use list command instead. (This underlines the necessity of always having a test period before final release). regards Jens Lauritsen Coordinator and initiator of EpiData Project http://www.epidata.dk

1 0

How To: Compare treatment A and B, when not given on all days for all patients
by epidata-list＠lists.umanitoba.ca 25 Apr '08

25 Apr '08

For a medication study we wish to test the hypothesis of no diffence in use of additional morphine for patients given two different pain regimens. The data collected for each patient is the date and time of additional medication from day one until day seven. The number of additional medication given varies from 0 to many. Therefore we record the data as: id : patient id d : date of medication m : Dosage of the medication Basic data are saved for each patient grp : treatment group, A vs. B dayop : Date of surgery For the analysis we also need: variable m : sum of additional morphica given varable d : day of treatment This would seem easy: read medication * add day of surgery etc.: merge id /table=basicdata gen i day = d - dayop * now aggregate on day of medication aggregate id day grp /sum=m * save for later: savedata daymedication /replace * this creates the summary variable summ for m * summ contains the sum of medication on each day for each patient means summ /by=grp /t : overall means summ /by=grp / t if day = 1 : example comparison on day one. But this will give a wrong result, since only persons given medication are recorded in the medication file. We therefore need to restructure the analysis: A. Create a complete file for all patients: * generate file of patient id' numbers * (here 22 patients on day one and two): generate 44 gen i idn = recnumber +1 * we need two lines for each patient: gen i id = (idn div 2) gen i grp = 1 * our dataset is such that first 11 patients are group 1 and remaining group 2: if id > 11 then grp = 2 gen i day = 1 if (id = id[recnumber-1]) then day = 2 drop idn labeldata "Key file for all patients" savedata key /replace * this file now contains exactly one record for all patients on each of day one and two. B now we can analyse the data again: (notice the daymedication file created above) * get the complete file: Read key /close * add medication information: merge id day /table=daymedication * add basic information on merge id /table=basicdata * for patients with no medication summ is equal to . (missing) recode summ .=0 * now summ contains the sum of medication on each day for each patient * show the observations for all days: * generate indicator variable based on day and group gen i g = 10*(grp-1) + day labelvalue g /1="Case Day 1" /2="Day 2" /11="Control day 1" /12="Day 2" * verify distribution of summ as a probit plot cdfplot summ /p * for aggregation in the cdfplot the variable must be integer: gen i mx = integer(summ*1000) cdfplot mx /p /agg * for my specific data showing a straight line * (with a slight "too many at zero" problem) * show as box and dotplot: box summ /by=g /n /out dotplot summ /by=g /sizex=600 /xa /di=0.25 /ti="Amount given - patient level" * finally test the hypothesis means summ /by=grp /t : overall means summ /by=grp if day = 1 : comparison on day one. means summ /by=grp if day = 2 : comparison on day two. Jens Lauritsen Coordinator and initiator of EpiData Project http://www.epidata.dk

1 0

Jump command
by epidata-list＠lists.umanitoba.ca 22 Apr '08

22 Apr '08

Dear EpiData lister, I have field v4 that has formula v4=v3-v2 any way to let the cursor jumps from v3 to v5? thank you and best regards ziad

1 2

Epi data mailing list
by epidata-list＠lists.umanitoba.ca 21 Apr '08

21 Apr '08

Please confirm 78db47628922fd527350fbdaadfc20cf854513cc. Thank you, Nino

1 0