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]
Re: st: MM/DD/YYYY string to stata date
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: MM/DD/YYYY string to stata date
Date
Mon, 4 Jun 2012 23:42:51 +0100
To expand a bit: If you remove the separators, you make it harder for
Stata. It can deal with dates of the form "ddmmyyyy", "DMY" or
"ddmmyy", "DMY", "yyyy", but yours don't fit either pattern.
Nick
On Mon, Jun 4, 2012 at 9:16 PM, Abhimanyu Arora
<[email protected]> wrote:
> I guess it works OK if instead of
> gen newstrvar = subinstr(strvar, "/", "", .) you type in
> gen newstrvar = subinstr(strvar, "/", "-", .) and then the date function.
>
> On Mon, Jun 4, 2012 at 9:36 PM, Lars Folkestad <[email protected]> wrote:
>> 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?
*
* 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/