Statalist


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

RE: st:egen mean excludign any variable with missing values


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st:egen mean excludign any variable with missing values
Date   Mon, 8 Jun 2009 10:21:33 +0100

Roy's solution is good. I just want to underline that the title is
wrong. The problem is clearly to do with excluding observations, not
variables. 

Nick 
n.j.cox@durham.ac.uk 

Roy Wada
 
> 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
> respondent.
> 
> Mandy

You can take advantage of -reg- to perform casewise deletion.
 
qui reg y x-x8
foreach v of varlist Y x1-x8 {
   by id: egen mean_`v'=mean(`v') if e(sample)==1
}


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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