- EpiData-list - University of Manitoba Mailing Lists

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

substring in data entry check file
by epidata-list＠lists.umanitoba.ca 22 Nov '10

22 Nov '10

Hi, In epi info 6.04d for DOS it is possible to take a substring using square brackets to index the characters wanted, e.g. firstname[1,1] gives the first letter of the firstname field. Is there anyway to do this in epidata? Using [1,1] like this does not seem to work. It does not throw an error, it just does not do what I want it to do (fill in another field). 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 4

Re: [EpiData-list] Roster for household questionnaire
by epidata-list＠lists.umanitoba.ca 13 Nov '10

13 Nov '10

I agree that related files would work better in this case. In the current public release, however, related files are not fully integrated. For example, it is (as far as I can tell) impossible to do double entry on a record that has related files. I think the best solution would be to work on fully integrating related files into the program. If this is not possible, then the function for roster variables described by Mensah would be second best. -Sam -----Original Message----- Date: Thu, 11 Nov 2010 23:05:26 -0500 From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] Roster for household questionnaire To: epidata-list(a)lists.umanitoba.ca Message-ID: <BLU0-SMTP51E700F7DE8AA4536619A2FD330(a)phx.gbl> Content-Type: text/plain; charset="us-ascii" This is something I would use related files for, especially when you don't know how many household members there will be. We'll have to wait to see how they work in Manager/Entry. If you have parts of questionnaires you will use often, including more than once in the same project (questionnaire), simply create a short .qes for them and import that .qes structure multiple times into Manager. This works very well. You can then alter the Vnn field names yourself. Jamie On 2010-11-11, Mensah wrote: > Is it possible to have the function for a roster variables instead of > doing it manual. > for instance in CSpro, there is a roster function of designing a household > data that repeat several * *times, but in epidata you have to do it manual.

1 1

RE: EpiData-list Digest, Vol 85, Issue 6
by epidata-list＠lists.umanitoba.ca 12 Nov '10

12 Nov '10

I am using EpiData Verion 3.1. I did send a screenshot, but apparently only text is allowed by the list. Many thanks, Shakeel -----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: 11 November 2010 18:01 To: epidata-list(a)lists.umanitoba.ca Subject: EpiData-list Digest, Vol 85, Issue 6 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. Overlapping text/ answer box (epidata-list(a)lists.umanitoba.ca) 2. Re: Overlapping text/ answer box (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Thu, 11 Nov 2010 08:52:33 -0000 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Overlapping text/ answer box To: <epidata-list(a)lists.umanitoba.ca> Message-ID: <6FB4A65524882E48B6BEA9636B2628323693D3(a)colhpaexc015.HPA.org.uk> Content-Type: text/plain; charset="us-ascii" I don't use epidata very often, so this is probably a very basic question. I have created a form, but when I preview it, there are a few questions where the questions and answer boxes overlap (as shown in the attached). There is no overlap in design view and I am struggling to work out why this is happening. Any suggestions would be most welcome. Thanks, Shakeel Suleman ----------------------------------------- ************************************************************************ ** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of the HPA, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses, but please re-sweep any attachments before opening or saving. HTTP://www.HPA.org.uk ************************************************************************ ** ------------------------------ Message: 2 Date: Thu, 11 Nov 2010 10:07:22 +0100 From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] Overlapping text/ answer box To: epidata-list(a)lists.umanitoba.ca Message-ID: <4CDBB24A.2090105(a)epidata.dk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 2010-11-11 09:52, epidata-list(a)lists.umanitoba.ca wrote: > I don't use epidata very often, so this is probably a very basic > question. I have created a form, but when I preview it, there are a few > questions where the questions and answer boxes overlap (as shown in the > attached). There is no overlap in design view and I am struggling to > work out why this is happening. Any suggestions would be most welcome. > > > > Thanks, > > > > Shakeel Suleman Dear Shakeel I think you forgot to attach the screenshot you mention. Also please tell which program that you refer to, the "old" Entry program or the test version the "new" EpiData EntryClient program. 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 85, Issue 6 ******************************************* ----------------------------------------- ************************************************************************** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of the HPA, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses, but please re-sweep any attachments before opening or saving. HTTP://www.HPA.org.uk **************************************************************************

1 4

Roster for household questionnaire
by epidata-list＠lists.umanitoba.ca 11 Nov '10

11 Nov '10

Hello Jen and Team, Nice work on the new epidata software manager and client, which is under test. Is it possible to have the function for a roster variables instead of doing it manual. for instance in CSpro, there is a roster function of designing a household data that repeat several * *times, but in epidata you have to do it manual. illustration: Household Member 1 Age Sex Gender 2 3 4 -- ............ MENSAH KOJO SEDZRO P.O.Box AS 387 Ashaiman -Tema Ghana House : +233-3033-300789 MOBILE : +233-244-458788 -------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

1 1

Overlapping text/ answer box
by epidata-list＠lists.umanitoba.ca 11 Nov '10

11 Nov '10

I don't use epidata very often, so this is probably a very basic question. I have created a form, but when I preview it, there are a few questions where the questions and answer boxes overlap (as shown in the attached). There is no overlap in design view and I am struggling to work out why this is happening. Any suggestions would be most welcome. Thanks, Shakeel Suleman ----------------------------------------- ************************************************************************** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of the HPA, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses, but please re-sweep any attachments before opening or saving. HTTP://www.HPA.org.uk **************************************************************************

1 1

test version of analysis ready (read epx file - new Odds Ratio calculation)
by epidata-list＠lists.umanitoba.ca 07 Nov '10

07 Nov '10

A new test release of EpiData Analysis has been placed for download on the testing page. http://epidata.dk/testing.php The zip file contains a complete working copy, including updated help file. When you unzip please maintain folder structure. An EPX formatted version of bromar data is included in the zip file. Changes from previous releases are: A. Ability to read xml formatted files created by EpiData Manager (EPX) files (NOT EPZ zipped files) B. The default principle of Odds Ratio calculation has been changed from: MLE based to: Standard simple with Robins, Greenland, Breslow 95% CI to get the new default Odds Ratios use: /o , to use the same as previously: /oex Output is slightly changed, example: . tab runok sex /o /oex Outcome:Marathon race completed ? Sex of runner 1 0 Total 2 3119 418 3537 1 437 53 490 Total 3556 471 4027 Exposure: Sex of runner = 2Outcome: Marathon race completed ? = 1 Odds Ratio = 0.90 (95% CI: 0.67-1.23) (Robins,Greenland,Breslow CI) Exact (MLE) Odds Ratio = 0.90 (95% CI: 0.66-1.23) pORex<=1.0 = 0.2872 With this test release users are more than welcome to challenge the whole cycle of creating files in Manager (including import fra Stata, Rec, QES files, pasting via clipboard or editor etc), entering data with the EntryClient and analysing the data in Analysis. You may use the Manager to export data to Stata for comparisons of results. Anything not working - or comments to the way we have implemented aspects - please report to this list or if you find reproducible errors it is easier for us, if you can report to the flyspray system - see link on the testing page. regards Jens Lauritsen

1 2

EpiData-list Digest
by epidata-list＠lists.umanitoba.ca 06 Nov '10

06 Nov '10

Hello, Thank you for your response about police and presentation in future Epidata Manager, I understand the problem. But is it possible only for the size of the police for the titles for example..... ??? Also, in Epidata Analysis, there are two things that cause problems for teachers and users: - Following the command "freq", numbers order is not exactly descending in case of negative numbers. - Following the command "lifetable", P50 is sometimes wrong (if small population). .... and another thing that would make life easier: - Following the command "scatter", a regression line, like in EPI-INFO DOS with "/r", would be interesting . I have a method but is longer (with creation of new variable with equation of the line through "var result", and scatter with three variables). Thanks for EPIDATA. Bernard Branger, Nantes, France -- J’utilise la version gratuite de SPAMfighter pour utilisateurs privés. Jusqu’à présent SPAMfighter a bloqué 2261 courriels spam. Nous avons en ce moment 7 millions d’utilisateurs de par le monde entier. Les utlisateurs payants n’ont pas ce message. Vous pouvez télécharger la version gratuite: http://www.spamfighter.com/lfr

1 0