producing new variable based on the mean of three variables

[Noor Hamad]

Hi,

I would like to calculate the mean of systolic blood pressure based on three observations for each participants, so I have 3 variables and I want to calculate the men for each row to produce new variable. Also, some observations are missing.

Thank you in advance.

[Nick Cox]

It's either three observations or three variables. Let's guess the first.

egen mean = mean(systolic), by(id)

will take care of missing values too. If that doesn't help, please show a data example.

[Noor Hamad]

Thank you very much Nick for your help. I was looking for three variables, but I was able to reach the right command.

[Nick Cox]

 
 egen mean = rowmean(systolic1 systolic2 systolic)

[Noor Hamad]

Thank you for your help Mr. Nick.