Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

st: combining data on same case from different lines


From   Marcelo Jenny <marcelo.jenny@univie.ac.at>
To   statalist@hsphsun2.harvard.edu
Subject   st: combining data on same case from different lines
Date   Fri, 25 Jun 2010 13:28:10 +0200

Hello,

could anyone point me to how to resolve the following situation during the stage of data cleaning.

I have an excert from a data bank with several lines of data per real world case.
The data table looks like that:

caseid     date                stage             publication
1            01oct1990       indictment
1                                    indictment    Journal, No 3, page 10
2           10may1995       indictment
2                                    indictment    Journal, No 1, page 5

Either the date or the publication reference is missing for each case in one of the stata case lines. I'd like to fill in these missing data and then drop the duplicate lines of data.

Any help is appreciated.

Marcelo Jenny

--
Dr. Marcelo Jenny
Universität Wien
Institut für Staatswissenschaft/AUTNES
Hohenstaufengasse 9/7/4. Stock
A-1010 Wien
Tel.:++43-1-4277-49706
E-Mail: marcelo.jenny@univie.ac.at
http://staatswissenschaft.univie.ac.at/

begin:vcard
fn:Dr. Marcelo Jenny
n:Jenny;Dr. Marcelo
org;quoted-printable;quoted-printable:Universit=C3=A4t Wien;Institut f=C3=BCr Staatswissenschaft / Department of Government
adr;dom:;;Hohenstaufengasse 9/7;Wien;;1010
email;internet:marcelo.jenny@univie.ac.at
title:Univ.Ass. / Assistant Professor
tel;work:++43/4277-49706
tel;fax:++43-1-4277-9497
x-mozilla-html:FALSE
url:http://staatswissenschaft.univie.ac.at/
version:2.1
end:vcard



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