<>
*************
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: [email protected]
[mailto:[email protected]] 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/
