Mean if respondents have answerd atleast out of 3 variables

[dee moks]

Hi I would reaaly be grateful if anyone can help with providing a code for this.

I have 3 sets of variables relating to the same thing. I was wondering what code I can use to calculate the mean of these variables if the respondents answered at least 2 of them. Many Thanks

[Nick Cox]

Where you say "3 sets of variables" I am going to guess that you mean "3 variables". Type

help egen

to find about rowmean() and rowmiss(). It sounds as if you want something with this flavour

egen wanted = rowmean(q1 q2 q3)
egen missing = rowmiss(q1 q2 q3)
replace wanted = . if missing > 1

In fact you can do it in one line

egen wanted = rowmean(q1 q2 q3) if (missing(q1) + missing(q2) + missing(q3)) <= 1

or

egen wanted = rowmean(q1 q2 q3) if (!missing(q1) + !missing(q2) + !missing(q3)) >= 2

[dee moks]

This worked fine, mant thanks