Statalist


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

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


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   AW: AW: st: add new record for individual in dataset
Date   Wed, 28 Oct 2009 13:33:46 +0100

<> 

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: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Jeph Herrin
Gesendet: Mittwoch, 28. Oktober 2009 13:33
An: statalist@hsphsun2.harvard.edu
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: 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/


*
*   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