Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Lars Folkestad <lfolkestad@health.sdu.dk> |
| To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
| Subject | st: MM/DD/YYYY string to stata date |
| Date | Mon, 4 Jun 2012 21:36:15 +0200 |
Dear list I know this is an old timer but i just dont get it. I have a variable indicating birth date. The variable is in string format and looks like this Mm/dd/yyyy If the the month or day is single digit it looks like this M/d/yyyy I have removed the /'s by gen newstrvar = subinstr(strvar, "/", "", .) But form there i dont get it. Ive used Gen newdate = date (newstrvar, "MDY") But that only gives me missing values. What am i doing wrong and is there an easy way to do this? lars * * 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/