Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: RE: combining data on same case from different lines
From 
 
"Nick Cox" <[email protected]> 
To 
 
<[email protected]> 
Subject 
 
st: RE: combining data on same case from different lines 
Date 
 
Fri, 25 Jun 2010 12:53:30 +0100 
A lot easier just to 
. drop if missing(date, publication) 
Please do not send .vcf to Statalist. 
Nick 
[email protected] 
Marcelo Jenny
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.
*
*   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/