[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st:egen mean excludign any variable with missing values

From   Mandy fu <>
Subject   st:egen mean excludign any variable with missing values
Date   Sun, 7 Jun 2009 21:37:40 -0400

Hi everyone,

I was wondering if anyone could give me some suggestion about
following question related to --egen-- command.

I want to demean variables Y, x1-x8 and then run an OLS regression of
these variables for a panel data set for respondents.  I think  I need
to be careful with the missing values in these variables. I'm not sure
to exclude any  respondent who has missing values for any of the
variable in Y, x1-x8 when calculating the group mean for each

**get the group mean (using id as group) without taking consideration
of mising values
foreach v of varlist Y x1-x8 {
    by id: egen mean_`v'=mean(`v')

In order to exclude the respondents with missing values for any
variable in Y, x1-x8, of course I can write out the condition like
 Y<. & x1<. & x2<.  .......................

I 'm sure there should be some easy way. Could anyone give me some hint?

Thanks in advance!

*   For searches and help try:

© Copyright 1996–2022 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index