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 at the end of May, 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   Richard Goldstein <richgold@ix.netcom.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: data management problem
Date   Fri, 16 Dec 2011 09:00:30 -0500

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
>      ... |    ...      |     ...                    |          ...
> 
> 
> Thanks.
> i
> 
> --
> Ivica Rubil
> Ekonomski institut / The Institute of Economics, Zagreb
> a. Trg J. F. Kennedyja 7, 10 000 Zagreb, Croatia
> t. +385-1-2362-269
> f. +385-1-2335-165
> e. irubil@eizg.hr
> www.eizg.hr
*
*   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