Re: st: data management problem

[Nick Cox <njcoxstata@gmail.com>]

There's an FAQ on such any and all problems.

Nick


On 16 Dec 2011, at 14:00, Richard Goldstein <richgold@ix.netcom.com>  
wrote:

> one way: use -egen- with the "max" function; here is an example:
>
> egen atleastone=max(dummy_member_is_pensioner), by(hh_id)
>
> Rich
>
> On 12/16/11 8:44 AM, Ivica Rubil wrote:
> > Dear Statalisters
> >
> > I have the first four variables in the table below in my dataset,  
> > and I
> > wish to generate the fifth variable. This variable should be such  
> > that
> > it is equal to 1 for all members of a particular household if there  
> > is
> > at least one pensioner in this household. Below is the table with  
> > only
> > two households one of which contains at least one pensioner and I  
> > wish
> > to assign 1 to each member of this household. The other household
> > doesn't contain any pensioner and I wish to assign 0 to each member  
> > of
> > this household.
> >
> > How to do that???
> >
> >
> >  hh_id  |   hh_member | dummy_member_is_pensioner  |
> > dummy_hh_with_at_least_one_pensioner
> >
> > --- 
> > ---|-------------|----------------------------|----------------------
> > ----------------
> >     1   |    1        |      1                     |           1
> >     1   |    2        |      1                     |           1
> >     1   |    3        |      0                     |           1
> >     1   |    4        |      0                     |           1
> >     2   |    1        |      0                     |           0
> >     2   |    2        |      0                     |           0
> >     2   |    3        |      0                     |           0
> >     ... |    ...      |     ...                    |          ...
*
*   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/