- EpiData-list - University of Manitoba Mailing Lists

How to select earlier date from multiple dates
by epidata-list＠lists.umanitoba.ca 09 Sep '11

09 Sep '11

Dear Forum Members, I was looking a way to select earliest date from multiple date fields. Example, Five date fields with dates as below, DateA - 13/01/2002 DateB - *13/01/2001* DateC - 13/01/2002 DateE - 13/01/2003 DateF - 13/01/2004 So, the programming to select earliest date (13/01/2001) in the field called "DateDiagnosis" Thanks in advance. Bijay Adhikari, PhD CD Epidemiologist Regina, SK

1 1

Combining logical operators
by epidata-list＠lists.umanitoba.ca 08 Sep '11

08 Sep '11

Is it possible to combine AND and OR into a single IF statement. If so, how? I have variables for the number of cups of tea consumed per day/week/month. The 3 variables are teapd, teapwk and teapmth. Only one of these should be filled in. -1 is the missing code and a value>0 indicates the number of cups consumed. I tried the following: BEFORE ENTRY IF ((teapd>0) AND (teapwk>0)) OR ((teapd>0) AND (teapmth>0)) OR ((teapwk>0) AND (teapmth>0)) THEN HELP "Only one of tea per day/week/month should have contain the number of cups" TYPE=ERROR ENDIF END This works for the paring of teapd and teapwk, but not the other parings, i.e. the "if" condition seems to stop at the first OR. A way around it is to split this into 3 statements (see below), but I suspect there may be a more elegant way to do what I want. BEFORE ENTRY IF (teapd>0) AND (teapwk>0) THEN HELP "Only one of tea per day/week/month should have contain the number of cups" TYPE=ERROR ENDIF END BEFORE ENTRY IF (teapd>0) AND (teapmth>0) THEN HELP "Only one of tea per day/week/month should have contain the number of cups" TYPE=ERROR ENDIF END BEFORE ENTRY IF (teapwk>0) AND (teapmth>0) THEN HELP "Only one of tea per day/week/month should have contain the number of cups" TYPE=ERROR ENDIF END 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 2

I can't export questions including chinese characters to Stata
by epidata-list＠lists.umanitoba.ca 08 Sep '11

08 Sep '11

Dear friends, I can't normally export questions including chinese characters to Stata. When I open .dta file in Stata, the variables just display "???" in label.Can you help me? Thanks! Best regards,Richard Zhou > Date: Mon, 5 Sep 2011 12:00:27 -0500 > From: epidata-list-request(a)lists.umanitoba.ca > Subject: EpiData-list Digest, Vol 95, Issue 5 > To: epidata-list(a)lists.umanitoba.ca > > 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. Updated version of EpiData Manager release for MAC only. > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 05 Sep 2011 14:41:46 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Updated version of EpiData Manager release for > MAC only. > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4E64C38A.6020208(a)epidata.dk> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Dear list. > > Due to a significant bug in EpiData Manager we have release a new > updated version of the program. > > The bug allowed a user to overwrite an existing project file > (.epx/.epz), by using "Save As...", > but without being warned that the file would be overwritten. > > This bug only affects the MAC version of EpiData Manager. > > > Kind regards, > Torsten Bonde Christiansen > EpiData Association. > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 95, Issue 5 > *******************************************

1 0

Updated version of EpiData Manager release for MAC only.
by epidata-list＠lists.umanitoba.ca 05 Sep '11

05 Sep '11

Dear list. Due to a significant bug in EpiData Manager we have release a new updated version of the program. The bug allowed a user to overwrite an existing project file (.epx/.epz), by using "Save As...", but without being warned that the file would be overwritten. This bug only affects the MAC version of EpiData Manager. Kind regards, Torsten Bonde Christiansen EpiData Association.

1 0

New test version of Manager and Analysis
by epidata-list＠lists.umanitoba.ca 03 Sep '11

03 Sep '11

The release of September 2nd is a minor update for Manager and EpiData Analysis, in which a few bug have been found and fixed. Manager: * Fixed bug where exporting to STATA did not export valuelabels. * Added support for importing .rec files with password protection. * Fixed minor bug where importing .rec files with valuelabels under special circumstances were not imported correctly. * Fixed significant bug in importing structure of STATA files could render computer useless (HUGE memory usage). * Fixed significant bug where deleting a section, with fields/heading moved out of could also delete the fields/headings. * Added "space extender". A heading is placed a "page" down on the designer, to extend the working area for placing fields, sections and headings. Analysis: * Fixed a bug where importing project files .epx/.epz would create a buggy .chk file on saving data from within Analysis. ==================================== Regards Torsten Christiansen and Jens Lauritsen EpiData Association

1 0

Re: conditional value label look-up?
by epidata-list＠lists.umanitoba.ca 03 Sep '11

03 Sep '11

We can use the following for the conditional value label look-up, disease AFTER ENTRY IF (disease='A') THEN GOTO subtypeA EXIT ENDIF IF (disease='B') THEN GOTO subtypeB ENDIF END END subtypeA COMMENT LEGAL USE label_subtypea SHOW TYPE COMMENT END subtypeB COMMENT LEGAL USE label_subtypeb SHOW TYPE COMMENT END Bijay Adhikari On Fri, Sep 2, 2011 at 11:00 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. Re: conditional value label look-up? > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 1 Sep 2011 20:29:35 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] conditional value label look-up? > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <BLU0-SMTP55572154E8DD723E0CAE91FD180(a)phx.gbl> > Content-Type: text/plain; charset="us-ascii" > > This is possible in the current version of EpiData. The syntax is shown in > the help file (.chk commands --> comment legal). It only works for comment > legal, not for legal. In my tests, it sometimes get confused. You can also > implement it, if your lists are short (as in your example), using nested if > ... then blocks. This may be better as the logic should be simple enough and > it will be bullet-proof. You can also provide error messages using the help > command. > > In the test version, there is not yet an equivalent way to do this, but > here is what I would do: > > create 4 fields: > > disease > sub1 > sub2 > subtype (string only will work) > > disease has jumps, to either sub1 or sub2, depending on its value > sub1 and sub2 have appropriate legal values, ranges or value labels > sub1 and sub2 have a calculation: subtype=sub1 in sub1 and subtype=sub2 in > sub2 > > subtype is NOENTER > > sub1 and sub2 have to jump to the field past subtype. I'm not sure whether > an unconditional jump is implemented yet. This may be problematic. > > Jamie > > On 2011-08-31, at 4:30 PM, epidata-list(a)lists.umanitoba.ca wrote: > > > Is there a way to do a conditional value label look up in either the > current or in the new test version of EpiData? > > > > For instance, if field disease equals A then field subtype has values > 1,2,3 for selection, if field disease equals B then field subtype has values > 4,5,6, etc. > > > > Thank-you, and well done to the development team for excellent progress. > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 95, Issue 2 > ******************************************* > -- Regards, ABJ "It is not the strongest of the species that survives, nor the most intelligent, but the one most responsive to change." Charles Darwin

1 0

Re: conditional value label look-up
by epidata-list＠lists.umanitoba.ca 03 Sep '11

03 Sep '11

Greetings. Is there a way to do a conditional value label look up in either the current or in the new test version of EpiData? For instance, if field disease equals A then field subtype has values 1,2,3 for selection, if field disease equals B then field subtype has values 4,5,6, etc. Thank-you, and well done to the development team for excellent progress. _______________________________________ Stephen Drew Health Data Analyst Region of Waterloo Public Health Waterloo, ON ======================================================================== Thanks Stephen, what about using the expression if: Example for disease A disease_A BEFORE ENTRY IF disease_A = 1 or "AFP" THEN Symptom = 1 GOTO admission ENDIF END END Next thing to be done is the following expression IF disease_B = 2 or "Yellow_Fever" THEN Symptom = 3 GOTO admission_tropic (i.e another subtype) ENDIF END END As you can see this can be very time consuming, however it could best done at the data management stage where you could create or generate new variable appropriately before cracking on with the analysis. However, if you really want to proceed with: "A then field subtype has values 1,2,3 for selection" then the other thing that you could do would be to assign a unique code; such as if field subtype has values 1,2,3, then coded it 1, for value 4-7 coded it 2; this will make it easy. I am struggling to understand why you need values 1, 2, 3 in the same field at the same time? Hope this helps Best wishes Tieble On 1 September 2011 18:00, <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 value label look-up? (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 31 Aug 2011 16:30:53 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] conditional value label look-up? > To: "'epidata-list(a)lists.umanitoba.ca'" > <epidata-list(a)lists.umanitoba.ca> > Message-ID: > < > 51AB587E44A99647912C34562ECADA570AF45AFBA1(a)MAIL.region.waterloo.on.ca> > > Content-Type: text/plain; charset="us-ascii" > > Greetings. > > Is there a way to do a conditional value label look up in either the > current or in the new test version of EpiData? > > For instance, if field disease equals A then field subtype has values 1,2,3 > for selection, if field disease equals B then field subtype has values > 4,5,6, etc. > > Thank-you, and well done to the development team for excellent progress. > _______________________________________ > Stephen Drew > Health Data Analyst > Region of Waterloo Public Health > Waterloo, ON > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 95, Issue 1 > ******************************************* > -- <http://www.vet2011.org/calendrier3.php>http://vet2011.org Vet for health, Vet for food, Vet for the planet ! <http://www.mgavm.ru/>

1 0

conditional value label look-up?
by epidata-list＠lists.umanitoba.ca 01 Sep '11

01 Sep '11

Greetings. Is there a way to do a conditional value label look up in either the current or in the new test version of EpiData? For instance, if field disease equals A then field subtype has values 1,2,3 for selection, if field disease equals B then field subtype has values 4,5,6, etc. Thank-you, and well done to the development team for excellent progress. _______________________________________ Stephen Drew Health Data Analyst Region of Waterloo Public Health Waterloo, ON

1 1

IF... THEN LEGAL
by epidata-list＠lists.umanitoba.ca 30 Aug '11

30 Aug '11

Hi all, I'm trying to combine IF... THEN with LEGAL but somehow I'm having problems with it. Basically, what I want to do is to determine valid values for one variable based on the answer given to another variable. In the example below, the two vars are stateid and countyid: If stateid = 1 then countyid could be 01 or 04; if stateid = 2 then countyid could be 02, 03 or 05. Example: countyid IF stateid = 1 THEN LEGAL 01 04 END ENDIF IF stateid = 2 THEN LEGAL 02 03 05 END ENDIF MUSTENTER END -- Thomaz A.

1 2

I can't normally export value labels to Stata 11
by epidata-list＠lists.umanitoba.ca 27 Aug '11

27 Aug '11

Dear friends, I can't normally export value labels to Stata 11 data file even using the newest sample.epx. Why? RegardsRichard Zhou > Date: Fri, 26 Aug 2011 12:00:29 -0500 > From: epidata-list-request(a)lists.umanitoba.ca > Subject: EpiData-list Digest, Vol 94, Issue 13 > To: epidata-list(a)lists.umanitoba.ca > > 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. Re: New test versions (manager, entryclient, template cmd > tool) (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 26 Aug 2011 13:25:02 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] New test versions (manager, entryclient, > template cmd tool) > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4E57828E.2030904(a)epidata.dk> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Dear All. > > As promised in our previous mail, we have released a new test version of > EpiData Analysis on our website today. > > This test release have been modified to support the new XML structure > used by the most recent versions of EpiData Manager and EpiData EntryClient. > > Along with this change, EpiData Analysis is now also capable of reading > the zipped versions of the project files. That is, it is now possible to > read the .epz files. > > With kind regards, > Torsten Bonde Christiansen. > EpiData Association. > > > On 2011-08-24 16:38, epidata-list(a)lists.umanitoba.ca wrote: > > > > Dear All > > > > As previously announced the programs released today have had a > > significant change to the underlying structure of the project file > > (the .epx/.epz XML structure). > > > > The reason for this is that the previous structure could not be > > described by a XML Schema file. A schema file is a standardised way of > > describing the structure and internal logic of an XML file. Some of > > the logical properties of the structure were inconsistent and > > therefore changed. This has as a positive "side effect" that the > > overall loading and saving time for a project file has improved quite > > a bit. > > > > The changes will - as warned two times on this list - break > > compatibility with > > previously created files. An updated version of the sample.epx file is > > provided with the downloads and additionally the EpiData Commandline > > Tool has been updated (and release for all platforms) to support the > > new XML structure. > > > > Please read previous mails on the list to see further explanation and > > how you can avoid problems in relation to the changed XML structure. > > > > The currently available test version of EpiData Analysis does NOT > > support the new XML structure. An updated version will be released in > > a few days. > > > > Common fixes/changes: > > * Updated XML structure > > * Import from STATA 12 now supported. > > * New saving algorithm, for improved speed. > > > > Manager: > > * Fixed a bug where removing a control marked for copy would cause > > breakdown if copy/paste was later invoked. > > * Fixed shortcuts for MAC. > > * Added boolean field to "other fields" > > * Fixed bug with "delete all" > > * Speed improvements for copy/paste and placing new controls (mainly > > visible with very many controls). > > > > EntryClient: > > * Fixed shortcut overlap in MAC > > * Speed improvements with loading project files. > > * Speed improvements when browsing records. > > > > EpiC: > > * Updated to support new XML structure. > > > > Regards > > > > Torsten Christiansen and Jens Lauritsen > > EpiData Association > > _______________________________________________ > > EpiData-list mailing list > > EpiData-list(a)lists.umanitoba.ca > > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 94, Issue 13 > ********************************************

1 0