March 2011 - EpiData-list - University of Manitoba Mailing Lists

Analysis: graph creating GUI bug?
by epidata-list＠lists.umanitoba.ca 30 Mar '11

30 Mar '11

Hello all, I noticed that the GUI which allows you to create histograms (Graph -> Histogram) does not let you specify a boolean variable as "by" variable. Example: . read C:\EpiData\TestData\bromar.rec . select dectime<>. . gen b fast=(dectime<3.87) it is possible to do the following: . his age /by=fast but the GUI form does not list "fast" as a "by" variable. Kind regards, Simon PS: I tried to report this on flyspray, but I get a "Error #23: User or group not enabled for login." when I try to log in.

1 2

New EpiData EntryClient version release for test
by epidata-list＠lists.umanitoba.ca 29 Mar '11

29 Mar '11

Dear List A new version of the EpiData EntryClient program have been release for testing today. Due to a significant bug in jumps, where the program would end up in an infinite loop, we have decided to release a new version where this problem is no longer present. Since the sample file contains a contruct that could activate this bug, we strongly recommend all using the old version of EpiData EntryClient (0.3.2.0) to update to the new version. With kind regards, Torsten Bonde Christiansen EpiData Association.

1 1

Clarification of how to work from now on
by epidata-list＠lists.umanitoba.ca 23 Mar '11

23 Mar '11

Dear all Many of the messages I have added to the list recently are rather technical in nature. This is just a short notice on how mode of work will be from now on: Until now - since 1999 and 2003/4 we have: Data definition, docuemtation and Entry: Epidata Entry Analysis: EpiData Analysis From now on: The manager: The project manager creates data entry forms and structures data collection using the software "EpiData (data) Manager". This can be used in a "point and click" manner visually including adding checks, jumps and ranges. Once the database is structured and ready. The file, e.g. outbreak.epx can be given to those entering data. The one "physical" file contains all information including definition of fields, range, value labels, jumps etc. The data entry person would then acquire the "EpiData EntryClient", which can be used to enter actual data into the file. Adding records just as in the current EpiData Entry software. In other words we separated current functionality into: Project management, data definition and documentation: EpiData Manager Data Entry: Epidata EntryClient Analysis: EpiData Analysis All of these are available from the testing page: Http://www.epidata.dk/testing.php We are now (struggling) to implement all decided functionality, such that a public release will be available as soon as possible. There is still some adaptations and developments to do, but we are approaching the public release. It is therefore welcomed that you look at the new software and join the commenting on the EpiData List - just as many of you have already done. Regards Jens Lauritsen EpiData Association

1 3

BoxPlot with 3 variables
by epidata-list＠lists.umanitoba.ca 23 Mar '11

23 Mar '11

Dear EpiData users, How to make a Boxplot when I have one quantitative variable and two qualitatives variablesThanks __________________________________ Konan Diby JP, MD, MPH Attaché de Recherche Labo. Biostatistique & Info. Médicale UFR Sciences Médicale, U. Abidjan-Cocody 22 BP 1041 Abidjan 22, Côte d'Ivoire Tel./Fax: (+225) 22 493 334 GSM: (+225) 08 167 578 / 02 724 162 skype's: dibykonanjp

1 1

Updated EpiData Manager
by epidata-list＠lists.umanitoba.ca 21 Mar '11

21 Mar '11

Dear EpiData users. Due to a significant bug in the previous version (0.7.1) of EpiData Manager, posted on the testing page last week, a new version has been upload today already. The bug impacted the use of "Import Structure" which could cause problem with saving the project, fields could be missing the field name and other strange problems could follow. Please be advised to download the new version uploaded today to avoid any of these problems. With kind regards, Torsten Bonde Christiansen EpiData Association.

1 1

WRITENOTE command
by epidata-list＠lists.umanitoba.ca 21 Mar '11

21 Mar '11

When writing a comment into a .NOT file, I can display the ID number by @<field name>, e.g. where the field name is babyid: * WRITENOTE "Comments or additional information for baby ID @babyid" SHOW I tried doing this with 2 fields (the combination of babyid and wksdate is unique): * WRITENOTE "Comments or additional information for baby ID @babyid and Week Starting date @wksdate" SHOW However only the value of wksdate is displayed. How can I display the values of both fields? My work around is to create a variable that's a combination of babyid and wksdate, but I'm wondering if there's a more straightforward way to do it. Cheers, Suzanna Vidmar Senior Research Officer Clinical Epidemiology and Biostatistics Unit Murdoch Childrens Research Institute Royal Children's Hospital Flemington Road Parkville Victoria 3052 Australia telephone: +61 3 9345 6372 facsimile: +61 3 9345 6000 email: suzanna.vidmar(a)mcri.edu.au www.mcri.edu.au <http://www.mcri.edu.au/> ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________

1 0

Can I start translating the spanish wiki?
by epidata-list＠lists.umanitoba.ca 20 Mar '11

20 Mar '11

Hello: Maybe is very soon to do this but I offer my help editing the spanish version of the wiki on my free time. Regards, -- Omar Bautista González - Colaborador en autogestión comunitaria desde República Dominicana

1 0

epx versus EPX , analysis and problems in test release
by epidata-list＠lists.umanitoba.ca 19 Mar '11

19 Mar '11

When working with files in windows there is no difference btw. "chk" and "CHK" as extension for a file, however in Linux (possibly also in MAC) there is a difference. This is also relevant for EPX versus epx. It turns out that apparently the new batch processor "epidatacmd" can give problems when creating files due to problems of "EPX" versus "epx" extensions. WHen using these files on a Linux pc a file with the name myfile.EPX will not show up on the "supported files", list in manager or client. Other issues when working with the latest released Manager and EntryClient I have found are: a. Sometimes "access violation" occurs when I change the setting in Manager of "showing variable names" or not. b. Sometimes single files created from templates with the epidatacmd processor and subsequently combined in the Manager with "import structure" cannot be read by EpiDataClient. These errors will be fixed - these are examples of why testing is important on the path to the first public release. An updated Analysis (build 175) has been placed on the http://epidata.dk/testing.php. The only change is adaptation of reading epx files with the most recent changes to the epx structure. regards Jens Lauritsen EpiData Association .....................................................................................

1 0

RE: [EpiData-list] Re: EpiData Entry Program Exceeding 999 Lines
by epidata-list＠lists.umanitoba.ca 17 Mar '11

17 Mar '11

Dear Sam: You have your unique identifier for the parent file that is "inherited" by the child file. In the child file your create a unique identifier for that (simple is a construct of the parent identifier plus the date, if each child event happens on a different date). For validation, you compare the two parent files and the two child files, and that's it. Best regards, Hans Hi, The only problem with this solution is that I then cannot use the double entry method that compares responses as they are keyed in. As far as I know, it is not possible to do that with relational files. Thanks, Sam -- Hans L Rieder, MD, MPH Jetzikofenstr 12 3038 Kirchlindach Switzerland Tel: +41 31 829 4577 Mob: +41 79 321 9122 Web: http://www.tbrieder.org

1 0

Re: EpiData Entry Program Exceeding 999 Lines
by epidata-list＠lists.umanitoba.ca 17 Mar '11

17 Mar '11

Hi Sam, To add on Jens's suggestion, you could also give very short name to your variables without much description and fit all within required lines. Otherwise I would recommend relational rec.files (with full description of each var to avoid suffering at the data cleaning stage) and merge them at the end. Best wishes Tieble <http://www.mgavm.ru/>

1 2

Updated Manager and EntryClient for testing
by epidata-list＠lists.umanitoba.ca 17 Mar '11

17 Mar '11

Dear All We are (rapidly) approaching the first public release (not being a test version) of the updated software, which shifts to an XML based data structure. An updated version of the Manager and EntryClient has been placed for download on http://www.epidata.dk/testing.php Apart from several bug-fixes these are the main aspects: 1. We have created a new command line tool which can create dataforms, including setting of value labels, range and jumps (as announced yesterday), from a text file. 2. We have chosen - as previously announced - to discontinue "paste as qes" in Manager as a consequence of point 1. 3. The Manager can now add structure from several files to a dataform. e.g. for outbreak analysis one could have dataforms (epx files) for: diary fish meat vegetable drinks dessert etc. To create a data collection form for a specific outbreak: 1. Start manager and create a new project 2. Point at all relevant files E.g.: drinks, fish, vegetable 3. Change sequence of files in the grid showing the files chosen 4. The manager will then add the files. 5. Finetune the created combined file - e.g. add more jumps or specifications. The focus on ability to create a database in batch with Epidatacmd is part of an ECDC (European Union) funded project, which will be announced in detail later. The project is part of collaboration with Statens Serum Institut in Denmark (ssi.dk) and the similar Norwegian institute. The funding is currently coming from the ECDC project, plus donations and collaborations as shown on the http://epidata.dk/funding.htm page, including APHEO and MSF. But I do see the need for more funding to conclude the rewriting of Analysis plus remaining aspects of Manager plus EntryClient. I will actively seek this in the coming time. (Ideas welcomed). The development of the Manager and EntryCLient will focus on remaining issues before final public release. These include: size of font, printing, searching, key unique, repeat, validate dublicate files etc. All programming done by Torsten Christiansen. regards Jens Lauritsen EpiData Association

1 0

Re: EpiData-list Digest, Vol 89, Issue 2
by epidata-list＠lists.umanitoba.ca 16 Mar '11

16 Mar '11

Dear Jamie, I managed to download wine bottler.dmg but failed to open it saying it cannot be recognized. Is there any additional things I need to do before opening it Rgds Al > > > ------------------------------ > > Message: 2 > Date: Tue, 15 Mar 2011 09:53:04 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] EpiData for Mac > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <BLU0-SMTP51DE60B63BA698DF05BEF1FDCF0(a)phx.gbl> > Content-Type: text/plain; charset="us-ascii" > > Hi Aloysius, > > I've been using EpiData on my MacBook for the past year with no real problem. > > The old version (Entry, Analysis) run well under the Wine emulator. I > installed Winebottler (http://winebottler.kronenberg.org/) and then just > launch windows .exe files as if they were MAC applications. You can safely > install Winebottler and then forget about it. > > All of the EpiData documentation applies. Winebottler provides you with a > folder that acts like your C: drive and the rest of your MAC hard drive looks > like a Z: drive. > > The only problem I have had is using help for Entry, where you cannot see some > help pages. I'm not sure why. Analysis works with no problem. > > Your other approach would be to use Bootcamp to run Windows/XP. I didn't want > to do that. > > Jamie > > On 2011-03-15, Aloysius wrote: > >> I have just started using Epidata and I own a mac. There seem to be no >> detailed help guides to help follow and use the Mac version. Is it that its >> still under development? Is there anyone with access to this document > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 89, Issue 2 > *******************************************

1 1

new test release of EpiDataCmd batch processor (template tool)
by epidata-list＠lists.umanitoba.ca 16 Mar '11

16 Mar '11

Dear All Today a new software release for testing has been placed on Http://www.epidata.dk/testing.php Current test release is for Linux and Windows only. Mac version follows. The intention of this tool is that the user can produce standard epx files based on a template defining dataforms. Full documentation of the format is found at: http://www.epidata.org/dokuwiki/doku.php/documentation:templateformat The epidatacmd command line tool will create EpiData xml files based on template files.: Template files should be using UTF-8 To see options: epidatacmd -h Example file included: templatesample.tmpl to execute this: linux: ./epidatacmd template -i templatesample.tmpl -o diary.epx windows: epidatacmd template -i templatesample.tmpl -o diary.epx EpiData Association, Denmark, 2011-March Programming: Torsten Christiansen (TC) Design: Jens Lauritsen and TC

1 0

Re: EpiData-list Digest, Vol 89, Issue 2
by epidata-list＠lists.umanitoba.ca 16 Mar '11

16 Mar '11

Hi All, I do not know how to design data entry form for pre and post test training course to we can compare how to improve of each person before and after training coures. Wish help of all. Best, Linh On Wed, Mar 16, 2011 at 12:18 AM, <epidata-list-request(a)lists.umanitoba.ca>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. EpiData for Mac (epidata-list(a)lists.umanitoba.ca) > 2. Re: EpiData for Mac (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 15 Mar 2011 15:40:33 +0300 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] EpiData for Mac > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <C9A538F1.5AC1%ASSEMAGANDA(a)IAVI.OR.UG> > Content-Type: text/plain; charset="iso-8859-1" > > Dear EpiData colleagues, > I have just started using Epidata and I own a mac. There seem to be no > detailed help guides to help follow and use the Mac version. Is it that its > still under development? Is there anyone with access to this document > > Kind Regards > Aloysius Ssemaganda > UVRI/IAVI HIV Vaccine Program > Uganda Virus Research Institute > P.O.Box 49 Entebbe,Uganda. > Tel: +256 414 322 377/8,+256 414 321 094 > Cell: +256 782 334 633 > Fax: + 256 414 321 124 > Email: assemaganda(a)iavi.or.ug or assemaganda(a)gmail.com > > > > > > > ------------------------------ > > Message: 2 > Date: Tue, 15 Mar 2011 09:53:04 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] EpiData for Mac > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <BLU0-SMTP51DE60B63BA698DF05BEF1FDCF0(a)phx.gbl> > Content-Type: text/plain; charset="us-ascii" > > Hi Aloysius, > > I've been using EpiData on my MacBook for the past year with no real > problem. > > The old version (Entry, Analysis) run well under the Wine emulator. I > installed Winebottler (http://winebottler.kronenberg.org/) and then just > launch windows .exe files as if they were MAC applications. You can safely > install Winebottler and then forget about it. > > All of the EpiData documentation applies. Winebottler provides you with a > folder that acts like your C: drive and the rest of your MAC hard drive > looks like a Z: drive. > > The only problem I have had is using help for Entry, where you cannot see > some help pages. I'm not sure why. Analysis works with no problem. > > Your other approach would be to use Bootcamp to run Windows/XP. I didn't > want to do that. > > Jamie > > On 2011-03-15, Aloysius wrote: > > > I have just started using Epidata and I own a mac. There seem to be no > > detailed help guides to help follow and use the Mac version. Is it that > its > > still under development? Is there anyone with access to this document > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 89, Issue 2 > ******************************************* > -- ================================== Nguyen Thi Linh Institute of Social and Medical Studies No 17, Residence of Cau Giay District Health Center. Alley 1, Nguyen Thi Dinh Street-Cau Giay-Ha Noi Phone: 84-4-35558288 ext. 105 Cell: 0977.999.087 Fax: 84-4-35558274 Website: www.isms.org.vn www.newcare.com.vn

1 0

Re: EpiData-list Digest, Vol 89, Issue 1
by epidata-list＠lists.umanitoba.ca 16 Mar '11

16 Mar '11

Thank you Jens for suggestion. It was helpful. I was trying to automate at entry, so did the following and it works, MSM RANGE 0 9 AFTER ENTRY IF (a = 1) and (b=0) THEN MSM=0 ENDIF IF (a = 1) and (b= 1) THEN MSM=1 ENDIF IF (a = 1) and (b= 1) and (c= 0) THEN MSM=2 ENDIF IF (a = 1) and (b= 1) and (c= 1) THEN MSM=3 ENDIF IF (a = 1) and (b= 1) and (c= 1) and (d = 0) THEN MSM=0 ENDIF IF (a = 1) and (b= 1) and (c= 1) and (d = 1) THEN MSM=4 ENDIF IF (a = 1) and (b= 1) and (c= 1) and (d = 1) and (e=0) THEN MSM=9 ENDIF END END *Bijay Adhikari*, PhD, MPH, DVM Prov. Communicable Disease Epidemiologist Population Health Branch Saskatchewan Ministry of Health Regina, SK Canada On Sat, Mar 12, 2011 at 12:00 PM, <epidata-list-request(a)lists.umanitoba.ca>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. Conditional formula (epidata-list(a)lists.umanitoba.ca) > 2. Re: Conditional formula (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 11 Mar 2011 18:43:02 -0600 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Conditional formula > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <AANLkTik4syh1ti3z-sqV=SA+ULthRgmLrfYYxjpj_H-m(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hello Epidata users, I am having problem to code conditional formula in > epidata as described below, can anyone suggest how to code to the following > condition, > > If a= 1 and b = 1 then exposure= K > > If a= 1 and b = 0 then exposure= K > > If a= 1 and b = 1 and c= 1 then exposure= K > > If a= 1 and b = 1 and c= 1 and d=0 then exposure= K > > If a= 1 and b = 1 and c= 1 and d=1 then exposure= K > > else exposure= K1 > > Thanks > > > -- > *Dr. Bijay Adhikari*, PhD, MPH, DVM* > Prov. Communicable Disease Epidemiologist > Population Health Branch > Saskatchewan Ministry of Health > Regina, SK Canada > > > ------------------------------ > > Message: 2 > Date: Sat, 12 Mar 2011 10:45:12 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Conditional formula > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4D7B40A8.8080601(a)epidata.dk> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hello Epidata users, I am having problem to code conditional formula in > > epidata as described below, can anyone suggest how to code to the > following > > condition, > I think the problem is that you should use more parenthesis. Is this in > analysis or in entry ? > > I assume analysis: > > * first create the integer variable k: > define k # > * or you could use the gen statement: "i" makes this an integer variable > gen i k = 0 > > * give labels > labelvalue k /0="No" /1="Yes" /9="Missing" /8="Not recoded" > > * now for certain conditions change exposure to "no" or yes: > * I just give different examples > * first I give all the value 8 to make sure I am in control of the > recoding: > k = 8 > If ( (a= 1) and (b = 1)) then exposure= 0 > If ( (f = 1) ) then exposure= 9 > If ( (a= 1) and (b = 1) and (c = 1) and (d = 1) ) then exposure= 1 > tab k > * if any records are stille with the value 8, then you would know there > is a problem. > > regards > Jens Lauritsen > EpiData Association > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 89, Issue 1 > ******************************************* >

1 0

EpiData Entry Program Exceeding 999 Lines
by epidata-list＠lists.umanitoba.ca 15 Mar '11

15 Mar '11

Hello, I am working on a project with a data entry program that exceeds 999 lines and I would like to avoid breaking the entry into sections (we would need at least 4 sections for our data entry program). Are there any tricks to work around this situation besides breaking up the program into several parts? If not, does anyone have suggestions for alternative programs to use for data entry on long surveys like this? I have heard that CSPro may work, but I have no experience with it. If you have any experience with CSPro or other data entry programs that might work, please email me directly ( Haddaway-sam(a)norc.org). Thanks, Sam Sam Haddaway | Research Analyst, International Projects NORC at the University of Chicago 4350 East-West Highway, 8th Floor, Bethesda MD 20814 haddaway-sam(a)norc.org <mailto:haddaway-sam@norc.org> | office +1 (301) 634-9423

1 1

EpiData for Mac
by epidata-list＠lists.umanitoba.ca 15 Mar '11

15 Mar '11

Dear EpiData colleagues, I have just started using Epidata and I own a mac. There seem to be no detailed help guides to help follow and use the Mac version. Is it that its still under development? Is there anyone with access to this document Kind Regards Aloysius Ssemaganda UVRI/IAVI HIV Vaccine Program Uganda Virus Research Institute P.O.Box 49 Entebbe,Uganda. Tel: +256 414 322 377/8,+256 414 321 094 Cell: +256 782 334 633 Fax: + 256 414 321 124 Email: assemaganda(a)iavi.or.ug or assemaganda(a)gmail.com

1 1

Conditional formula
by epidata-list＠lists.umanitoba.ca 12 Mar '11

12 Mar '11

Hello Epidata users, I am having problem to code conditional formula in epidata as described below, can anyone suggest how to code to the following condition, If a= 1 and b = 1 then exposure= K If a= 1 and b = 0 then exposure= K If a= 1 and b = 1 and c= 1 then exposure= K If a= 1 and b = 1 and c= 1 and d=0 then exposure= K If a= 1 and b = 1 and c= 1 and d=1 then exposure= K else exposure= K1 Thanks -- *Dr. Bijay Adhikari*, PhD, MPH, DVM* Prov. Communicable Disease Epidemiologist Population Health Branch Saskatchewan Ministry of Health Regina, SK Canada

1 1