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 <[email protected]> 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/
