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@lists.umanitoba.ca wrote:
Send EpiData-list mailing list submissions to epidata-list@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@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@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:
- Number of variables not missing (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Sat, 18 Dec 2010 18:02:36 +0100 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Number of variables not missing To: epidata-list@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@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 86, Issue 2