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

[Jeph Herrin <junk@spandrel.net>]

Then

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

will do it.

J


Martin Weiss wrote:
> <> 
>
> Stata probably won`t like the line "bys id : replace begin[2]=end[1]" and
> complain that "weights (are) not allowed"...
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Jeph Herrin
> Gesendet: Mittwoch, 28. Oktober 2009 13:08
> An: statalist@hsphsun2.harvard.edu
> Betreff: Re: st: add new record for individual in dataset
>
>
> 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/
>
>
> *
> *   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/