This is equivalent to
bysort hhid (indicode member) :
replace indicode = indicode[1]
if mi(indicode) & member == 1
(just one line)
Nick
[email protected]
Nick Cox
> The first non-missing value in each household is
>
> bysort hhid (indicode member) : gen firstnonmiss = indicode[1]
>
> except that this will return missing if all values
> in any household are missing.
>
> so it sounds as if you want to impute like this
>
> replace indicode = firstnonmiss if mi(indicode) & member == 1
>
> I can't see that -collapse- could help here.
Fanwell Kenala Bokosi
> > I want to generate a code for the household industry. The
> > household industry is the industry in which the household
> > head is engaged in. However for some households where the
> > industry code is missing for the household head, I want to
> > assign the next non missing industry code as the for the household.
> >
> > My data looks like this
> >
> > hhid member indicode
> > 1 1 1
> > 1 2 2
> > 1 3 3
> > 2 1 .
> > 2 2 4
> > 2 3 4
> > 3 1 .
> > 3 2 .
> > 3 3 1
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
