Antw: st: RE: use dummy variable for nonmissing data

["Rainald Borck" <Rainald.Borck@uni-passau.de>]

Nick,

sorry, probably I didn't explain myself well. I know Stata can't do anything with missing values. The question is this: say I have individuals from Germany in 1990 who all have missings in some variable y and I have created the dummy variable _IcouXyea_GER_1990.  When I leave this variable in a regression of, say y on all the country-year dummies, Stata will drop it because all individuals from Germany in 1990 have missing y and all those who have nonmissing have a 0 in _IcouXyea_GER_1990. So I want to tell Stata to use only those _IcouXyea_country_year where there are individuals in the country and year with nonmissing values. This would be convenient (rather than manually adjusting the output for all dropped dummies).

I tried by creating a variable nonmiss with values equal to 0 if there all individuals in a country in one year have missing values and 1 otherwise, and then

preserve

drop if nonmiss==0

xi. i.country*i.year, noomit

reg y var1  _IcouXyea*

restore

but this doesn't seem to work (neither without noomit).

Thanks
Rainald


>>> Nick Cox  14.01.11 17.01 Uhr >>>
This is just part of the default behaviour. Stata can't do anything statistical if values are missing and it ignores such observations. What do you think it could possibly do with them? 

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

Rainald Borck
 
I have survey data for individuals from several countries and years like this

id country year var1 var2
1 A 1900 1 2
...
200 B 1900 3 .
...


 
I have created country_year dummies using
xi i.country*i.year, noomit
 
Now I want to tell Stata to temporarily drop (or not use) the variable _IcouXyea_country_year if that country does not have observations for that year (i.e. the variable is missing for all individuals from that country and particular year). Can anyone help?

*
*   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/


*
*   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/