Yun,
If the last 2 chars are always the year (and year is all you need) then combine string functions to extract the last two chars. Something like:
gen new_dob="19"+substr(old_dob,length(dob)-2,2)
Maybe.
Bret
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Yun Liu
Sent: Wednesday, July 02, 2008 11:48 AM
To: [email protected]
Subject: st: recording date and year
Hi,
I have a question about recording date and year. I am dealing with a "date of birth" variable stored in an excel file. In some cases, it's a year. In some cases, it's month and year. In other cases, it's date and year. For examples,
1965
Nov-47
1952
1952
1953
10-Oct-40
What would be the best way to record this variable in stata? Thank you!
Yun
*
* 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/
*
* 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/
