- EpiData-list - University of Manitoba Mailing Lists

Multiple users entering data the same time?
by epidata-list＠lists.umanitoba.ca 17 Jan '11

17 Jan '11

Hi, Can epidata safely handle multiple users entering data into a single recfile at the same time? Thanks. David -- David Whiting, PhD | Senior Epidemiology & Public Health Specialist tel +32-2-6437945 | mob +32-496-266436 | David.Whiting(a)idf.org International Diabetes Federation 166 Chaussée de la Hulpe, B-1170 Brussels, Belgium tel +32-2-5385511 | fax +32-2-5385114 info(a)idf.org | www.idf.org | VAT BE 0433.674.528 IDF | Promoting diabetes care, prevention and a cure worldwide

1 2

EpiData manager test
by epidata-list＠lists.umanitoba.ca 14 Jan '11

14 Jan '11

Hi, I have tested EpiData manager and EpiData entry client. First : congratulations for this great job! It will be hard to forget the .qes .chk .rec system, but xml is a good choice for the future! Bug report and suggestions (I work on a PC with windows 7) : 1/ Entry client : - when entering a date without "/", the first slash is automatically inserted (like in EpiData entry), but not the second one, and a blank grey screen appears after pressing tab or enter. This screen disappears when pressing ESC -is a search function planned ? 2/ Manager - Moving fields or headings does not seem easy once they are created. Actually I can't find how to do it ! - A double click on an item should open the properties window - edition of the value labels is not intuitive. For example, it took me a long time to understand that I had to press enter to insert a new line - in value label edition : the image of the edited value label disappears when it is selected (first column on the left) - I created a new project and tried to enter new value labels : I could insert new lines but could not fill the "value" and "label" columns : they became blank after entering text and pressing enter That's all for now! Pascal THIBON, MD CHU Caen, Normandie France

1 2

new test release for EpiData Manager and Epidata EntryClient
by epidata-list＠lists.umanitoba.ca 11 Jan '11

11 Jan '11

Dear all As you all know we are approaching the change from the EpiData Entry released first time in 1999 to the updated and modernised EpiData Manager and EpiData EntryClient The main reasons for change have been published previously here on the list. Among these are needs for adaptation to modern data quality standards and in medical research projects the increasing demands for documentation in the form of so called Good Clinical Practice principles. More on this later. Today we have released major revisions the EpiData Manager and EpiData EntryClient programs. _*Major changes for both programs:*_ * Define *valuelabels* for a project. This includes definition and changes at file and field level. * Implementation of *range* for a field, which may also be combined with value labels * Users can save pdf files with instructions in a specified folder. Those present in that folder will be shown in the help menu "tutorials". This means that without programming you can create your own set of instruction materials. * Automatic timed back-up features during design and entry * Modernised design, e.g. showing recently used files. Manager: * Independent Value Label editor. * "Show Structure" form informing about contents and definitions in the project. * Statusbar more informative. dded possibility to store the positions of open forms. EntryClient: * Use "+" or F9 to show defined value labels. Based on input a guess is made within the list. * Auto ID (IDnum) fields work and can have specified initial value. * Floating fields now show full number of defined decimals. Please test the released software. With the software introduction documents are included and updated versions will be placed on the testing page of EpiData. Find all of this at: Http://www.epidata.dk/testing.php Please do report on this list of how you find the new versions. We are approaching first release and I am aware that many courses in the coming months rely on good and stable function of the new versions. All programming done by full time employed Torsten Christiansen. Possible due to donations as indicated on http://www.epidata.dk/funding.htm (donations are required for continued development) Regards Jens Lauritsen EpiData Association

1 2

RE: EpiData-list Digest, Vol 86, Issue 4
by epidata-list＠lists.umanitoba.ca 01 Jan '11

01 Jan '11

Thank you Jamie for your solution. I didn't know "iif" command in Analysis. Bernard BRANGER, Nantes, France -----Message d'origine----- De : epidata-list-bounces(a)lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] De la part de epidata-list-request(a)lists.umanitoba.ca Envoyé : lundi 27 décembre 2010 19:00 À : epidata-list(a)lists.umanitoba.ca Objet : EpiData-list Digest, Vol 86, Issue 4 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-list Digest, Vol 86, Issue 3 (epidata-list(a)lists.umanitoba.ca) 2. Re: EpiData-list Digest, Vol 86, Issue 3 (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Mon, 27 Dec 2010 11:38:50 +0100 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] EpiData-list Digest, Vol 86, Issue 3 To: <epidata-list(a)lists.umanitoba.ca> Message-ID: <4738E210DAFB460CBD3010042CD0F657@Ordinateurfixe> Content-Type: text/plain; charset="Windows-1252" Hello, Thank you for your reply, but I specify my problem: - Variables in the questionnaire Var1 ## Var2 ## Var3 ## Var4 ## Mean4 ##.## - In CHECK file (or ANALYSIS) mean4 mean4 = (var1+var2+var3+var4)/4 end - But sometimes, var2, for example, can fail (blank): in this case, "mean4" is the sum (Var1 to var4) divided by 3! - My question is, how to count automatically (CHECK or ANALYSIS) the number of variables (var1 to var4) not missing? Thank you for your help. B. BRANGER, Nantes, France

1 0

EpiData-list Digest, Vol 86, Issue 3
by epidata-list＠lists.umanitoba.ca 27 Dec '10

27 Dec '10

Hello, Thank you for your reply, but I specify my problem: - Variables in the questionnaire Var1 ## Var2 ## Var3 ## Var4 ## Mean4 ##.## - In CHECK file (or ANALYSIS) mean4 mean4 = (var1+var2+var3+var4)/4 end - But sometimes, var2, for example, can fail (blank): in this case, "mean4" is the sum (Var1 to var4) divided by 3! - My question is, how to count automatically (CHECK or ANALYSIS) the number of variables (var1 to var4) not missing? Thank you for your help. B. BRANGER, Nantes, France -----Message d'origine----- De : epidata-list-bounces(a)lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] De la part de epidata-list-request(a)lists.umanitoba.ca Envoyé : dimanche 19 décembre 2010 19:00 À : epidata-list(a)lists.umanitoba.ca Objet : EpiData-list Digest, Vol 86, 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. Re: Number of variables not missing (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Sat, 18 Dec 2010 20:52:21 +0000 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Re: Number of variables not missing To: epidata-list(a)lists.umanitoba.ca Message-ID: <AANLkTimm_vdw-KBwy03VcuDX5aXgUyZAB5k=JQbdzCU=(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Dear Bernard, What do you think about count if [logical statement]. For example: count if km=. will return the number of km that are missing in the data set. Additionally you can list such list id if km=. Please let me know if this helps. Tieble On 18 December 2010 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. Number of variables not missing (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 18 Dec 2010 18:02:36 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Number of variables not missing > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <6B03D7CCC9B74325BC1D373EEBCD70CF@Ordinateurfixe> > Content-Type: text/plain; charset="us-ascii" > > Hello, > > In EPIDATA ENTRY or ANALYSIS, to calculate an mean, it is easy to calculate > a sum of several variables (the numerator)(even if some are missing), but I > don't know calculate the number of non-missing variables (the denominator) > as the command "NBVAL" in EXCEL. Thank you for helping me. > > Bernard BRANGER, Nantes, France > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 86, Issue 2 > ******************************************* > -- http://www.vet2011.org/calendrier3.php ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 86, Issue 3 *******************************************

1 1

Re: Number of variables not missing
by epidata-list＠lists.umanitoba.ca 18 Dec '10

18 Dec '10

Dear Bernard, What do you think about count if [logical statement]. For example: count if km=. will return the number of km that are missing in the data set. Additionally you can list such list id if km=. Please let me know if this helps. Tieble On 18 December 2010 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. Number of variables not missing (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 18 Dec 2010 18:02:36 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Number of variables not missing > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <6B03D7CCC9B74325BC1D373EEBCD70CF@Ordinateurfixe> > Content-Type: text/plain; charset="us-ascii" > > Hello, > > In EPIDATA ENTRY or ANALYSIS, to calculate an mean, it is easy to calculate > a sum of several variables (the numerator)(even if some are missing), but I > don't know calculate the number of non-missing variables (the denominator) > as the command "NBVAL" in EXCEL. Thank you for helping me. > > Bernard BRANGER, Nantes, France > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 86, Issue 2 > ******************************************* > -- http://www.vet2011.org/calendrier3.php

1 0

Number of variables not missing
by epidata-list＠lists.umanitoba.ca 18 Dec '10

18 Dec '10

Hello, In EPIDATA ENTRY or ANALYSIS, to calculate an mean, it is easy to calculate a sum of several variables (the numerator)(even if some are missing), but I don't know calculate the number of non-missing variables (the denominator) as the command "NBVAL" in EXCEL. Thank you for helping me. Bernard BRANGER, Nantes, France

1 0

bugs in stattables command?
by epidata-list＠lists.umanitoba.ca 08 Dec '10

08 Dec '10

Hello all, I am trying to adapt a program written for an earlier version of EpiData to version 2.2.1.171. The command for the old version was . stab sex /mean="age" /des="age" which printed the following columns: sex, N, Nage, MEAage, MINage, MEDage, MAXage If I understand things correctly, I should be able to get the same table using the following command in the new version: . stab age /by=sex /stat="n mean des" However, I get a "Unknown aggregate function: N" when I try to execute the above command, even though the documentation mentions the parameter: * n Number of observations Also, interestingly, if I execute . stab age /by=sex /mean I get no error but just the table Sex | N ---------- M | 490 F | 3537 Instead of the mean. Are these bugs in EpiData or do I misunderstand the documentation? Kind regards, Simon

1 2

Re: Putting the content from several entry fields
by epidata-list＠lists.umanitoba.ca 26 Nov '10

26 Nov '10

Perhaps, you may want to create a field doctor_id (provided you have only few or up to 10). Then add label: 1 "Dr TH" 2 "Dr VM" 3 "DR HT" so on Then edit type comment Now you should be able to choose from the doctor_id, but you need to have doctor_id on each rec field. I would suggest that you try to do this in a simple way as two or more patients can be seen by the same and/ or different doctors. I don't know your research question but I have seen a case where patient A has been seen by Dr Smith then by Dr Brown too? Best wishes Tieble On 25 November 2010 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. Putting the content from several entry fileds into a value > label. (epidata-list(a)lists.umanitoba.ca) > 2. Re: Putting the content from several entry fileds into a > value label. (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 24 Nov 2010 23:54:40 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Putting the content from several entry fileds > into a value label. > To: "epidata-list(a)lists.umanitoba.ca" > <epidata-list(a)lists.umanitoba.ca> > Message-ID: > <FF3F33C7E13129439AFE23E87BD331F7C5B703BAD8(a)HORMXB102VM1.onerm.dk> > Content-Type: text/plain; charset="iso-8859-1" > > Hey > > I need help to find out if it is possible to have the content of several > data entry fields listed in a value label. > > I am doing a registration of data from patients files and need for > statistical purposes (cluster effect) to register the specific doctor that > has observed a given event, x-ray, bloodsample etc. > > I therefore thought of a way where you have one data entry field for each > doctor involved with patient and then everytime you need to assign a doctor > to a specific information a complete list (value label) defined by the > doctors you previously typed will show and you can then those instead of > typing it every time. > > How do I do that? Is there some way to write within the value label file > that allows a variable value to show? > > Thomas > > > ------------------------------ > > Message: 2 > Date: Wed, 24 Nov 2010 22:29:35 -0500 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Putting the content from several entry > fileds into a value label. > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <BLU0-SMTP51B6C094BB2891B9A04854FD200(a)phx.gbl> > Content-Type: text/plain; charset="us-ascii" > > There is probably a way to do this, using EPIC via the EXEC command to > create a small .rec on the fly that can be used as input to a conditional > COMMENT LEGAL. Analysis could also create the required .rec of legal values > for a patient, but I've never tried to use the EXEC command in a .chk file > to run Analysis. The kind of solution MIGHT work - I haven't tried it. > However, if none of the first sentence makes sense to you, it is probably > not worth trying it out. > > Why not just have a list of all of the doctors and pick from that list > every time a record is created. This ensures accurate entry of doctors, if > you know them all to begin with. Even if you have a few hundred doctors, an > alphabetic list is easy to present to the user via COMMENT LEGAL. > > EpiData does not have lookup feature that will let you type part of the > doctor's name and then see a partial list (except via conditional comment > legal). > The problem you state is handled "easily" (for an experienced user) by > relational databases that can create queries on the fly (ACCESS, etc). > > EpiData Entry does have a provision for running small programs to do this > sort of thing, but creating those small programs is a task for an > experienced programmer. If you have a mission critical requirement and this > function will be used every day by many people, it would be worth > programming it. > > In the long term, this could be an interesting feature to request to have > in the Entry Client - essentially the ability to recall from all existing > records, the unique values of one field, based on a filter - to be used as a > lookup table; plus the ability to add new values. This could be used very > frequently in many data entry applications. > > Jamie > > On 2010-11-24, Thomas wrote: > > > I need help to find out if it is possible to have the content of several > data entry fields listed in a value label. > > > > I am doing a registration of data from patients files and need for > statistical purposes (cluster effect) to register the specific doctor that > has observed a given event, x-ray, bloodsample etc. > > > > I therefore thought of a way where you have one data entry field for each > doctor involved with patient and then everytime you need to assign a doctor > to a specific information a complete list (value label) defined by the > doctors you previously typed will show and you can then those instead of > typing it every time. > > > > How do I do that? Is there some way to write within the value label file > that allows a variable value to show? > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 85, Issue 12 > ******************************************** > -- http://www.vet2011.org/calendrier3.php

1 0

Putting the content from several entry fileds into a value label.
by epidata-list＠lists.umanitoba.ca 24 Nov '10

24 Nov '10

Hey I need help to find out if it is possible to have the content of several data entry fields listed in a value label. I am doing a registration of data from patients files and need for statistical purposes (cluster effect) to register the specific doctor that has observed a given event, x-ray, bloodsample etc. I therefore thought of a way where you have one data entry field for each doctor involved with patient and then everytime you need to assign a doctor to a specific information a complete list (value label) defined by the doctors you previously typed will show and you can then those instead of typing it every time. How do I do that? Is there some way to write within the value label file that allows a variable value to show? Thomas

1 1