December 2010 - 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