Re: st: add new record for individual in dataset

[Jeph Herrin <junk@spandrel.net>]

Try

  expand 2
  bys id : replace begin[2]=end[1]
  bys id (begin) : replace end[2]=.
  bys id (begin) : replace cens[2]=1

hth,
Jeph


Marcus Casey wrote:
> Hi,
>
> Does anyone know how I can add a new record for an id in a long form  
> dataset?
> Specifically , I have a dataset with the following structure
>
> id	begin 	end		cens
> 1	1997	2006	   0
> 2 	1997	2003	   0
> 3	1997	2004	   0
> 3	2004	2007          0
> 4	1997	2006	   0
>
> and I want to add an additional record for each id in the following  
> manner
>
> id	begin	end		cens
> 1	1997	2006	    0
> 1	2006	   .		    1	
> 2  	1997	2003           0
> 2      2003	    .   	    1
> 3	1997	2004   	    0
> 3	2004	2007	    0
> 3	2007          .		    1
> 4	1997	2006	    0
> 4	2006	   .		    1
>
>
> Thanks in advance
>
> Regards,
> Marcus
>
>
>
> *
> *   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/
*
*   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/