Statalist


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

st: AW: add new record for individual in dataset


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

<> 



*************
clear*

input  byte(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

compress
list, noobs sepby(id)
tempfile temp
save `temp', replace

collapse (last) end, by(id)
rename end begin
gen end=.
gen cens=1

append using `temp'

order id begin end cens
sort id begin
list, noobs sepby(id)
*************



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Marcus Casey
Gesendet: Dienstag, 27. Oktober 2009 22:09
An: Statalist Statalist
Betreff: st: add new record for individual in dataset

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index