Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: replacing incorrect dob values


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: replacing incorrect dob values
Date   Thu, 24 Oct 2002 10:46:38 +0100

Ronan Conroy replied to Kim Price: 
> 
> > I need to replace some date of birth values that were entered
> > incorrectly.  The variable dob (V1) is entered as %d.  
> I've been using
> > variations on the following and coming up with error messages:
> > 
> > replace V1=05sep2046 05sep1946 if id==434
> > 
> > I want to change id 434's date from 05sep2046 to 05sep1946
> 
> -replace- needs the old value and the new value.  And the 
> variable you are
> changing is a string variable. You need to surround the old 
> and new values
> with quotes
> 
> > replace V1="05sep1946" if id==434
> 
> or
> 
> > replace V1="05sep1946" if V1=="05sep2046"
> 
> However, this is a brute force solution. Consider: if 
> people have impossible
> birthdates, then they will have a minus age. Consider
> 
> 1. calculating age normally
> 2. then using
> 
> replace age=age-100 if age < 0
> 

Pertinent if the date variable were being 
held as string; but as implied by stated %d
format, it is being held as a Stata date, 
namely as integers with base 1 January 1960. 
That is, you cannot assign format %d to 
a string variable. 

Nick 
n.j.cox@durham.ac.uk 
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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