Statalist


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

Re: st: AW: add new record for individual in dataset


From   Scott Merryman <scott.merryman@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: add new record for individual in dataset
Date   Wed, 28 Oct 2009 07:34:55 -0500

You are right - thanks.  A correction:


clear
input id      begin   end             cens

1       1997    2006       0
2       1997    2003       0
3       1997    2004       0
3       2004    2007          0
4       1997    2006       0
end

bys id: gen foo  = cond(_n == _N,2,1)
expand foo
bys id (begin): replace begin = end[_n-1] if _n >1
bys id: replace end = . if _n == _N
by id:replace cens = 1 if _n == _N
drop foo
l, sepby(id)

Scott



On Wed, Oct 28, 2009 at 7:25 AM, Martin Weiss <martin.weiss1@gmx.de> wrote:
>
> <>
>
>
> Your code puts the missing "end" into the first spell within "id", while
> Marcus wanted it to reside in the last one...
>
*
*   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   |   What's new   |   Site index