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
*******************************************
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
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
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