<>
It does it well, conditional on there being only 1 observation per id to
begin with, which is not the case for -id==3-
l ,noo sepby(id)
+--------------------------+
| id begin end cens |
|--------------------------|
| 1 1997 2006 0 |
| 1 2006 . 1 |
|--------------------------|
| 2 1997 2003 0 |
| 2 2003 . 1 |
|--------------------------|
| 3 1997 2004 0 |
| 3 1997 . 1 |
| 3 2004 2007 0 |
| 3 2007 2007 0 |
|--------------------------|
| 4 1997 2006 0 |
| 4 2006 . 1 |
+--------------------------+
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Jeph Herrin
Gesendet: Mittwoch, 28. Oktober 2009 13:33
An: [email protected]
Betreff: Re: AW: st: add new record for individual in dataset
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: [email protected]
> [mailto:[email protected]] Im Auftrag von Jeph Herrin
> Gesendet: Mittwoch, 28. Oktober 2009 13:08
> An: [email protected]
> 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/
*
* 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/
