- EpiData-list - University of Manitoba Mailing Lists

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

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