Thank you Jamie for your solution. I didn't know "iif" command in Analysis. Bernard BRANGER, Nantes, France

-----Message d'origine----- De : epidata-list-bounces@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] De la part de epidata-list-request@lists.umanitoba.ca Envoyé : lundi 27 décembre 2010 19:00 À : epidata-list@lists.umanitoba.ca Objet : EpiData-list Digest, Vol 86, Issue 4

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:

1. EpiData-list Digest, Vol 86, Issue 3 (epidata-list@lists.umanitoba.ca) 2. Re: EpiData-list Digest, Vol 86, Issue 3 (epidata-list@lists.umanitoba.ca)

----------------------------------------------------------------------

Message: 1 Date: Mon, 27 Dec 2010 11:38:50 +0100 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] EpiData-list Digest, Vol 86, Issue 3 To: epidata-list@lists.umanitoba.ca Message-ID: 4738E210DAFB460CBD3010042CD0F657@Ordinateurfixe Content-Type: text/plain; charset="Windows-1252"

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