Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: data management problem


From   Nick Cox <njcoxstata@gmail.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: data management problem
Date   Fri, 16 Dec 2011 14:17:11 +0000

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/


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