- EpiData-list - University of Manitoba Mailing Lists

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