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: appending date variable in 2 datafiles
From
<redacted>
To
[email protected]
Subject
Re: st: appending date variable in 2 datafiles
Date
Wed, 17 Oct 2012 12:31:11 +0100
Dear Nick,
Yes, the solution is very simple like you have said. I did
gen newDateVar = date(DateVar, "DMY")
format newDateVar %td
Thanks
<redacted>
On Wed, Oct 17, 2012 at 12:10 PM, Nick Cox <[email protected]> wrote:
> Stata prefers daily dates to be numeric variables coded with origin 1
> January 1960, so converting all date variables to that form is the way
> to go. (The difference you have is of variable or data type, not one
> of format in Stata's sense of the word.)
>
> You said that your variable was MDY, in response to which Stata can
> make no sense of the 5th day of the 23rd month, etc. But your variable
> is evidently DMY.
>
> Nick
>
> On Wed, Oct 17, 2012 at 11:58 AM, <redacted> wrote:
>
>> I have a date variable in a stata datafile :
>>
>> DATAFILE A
>>
>> +-----------+
>> doa
>> -----------
>> 1. 14dec2010
>> 2. 19dec2010
>> 3. 30mar2010
>> 4. 16jun2010
>> 5. 06jan2010
>> +-----------+
>>
>> and I have a date variable also in a stata datafile that I would like
>> to append to the datafile above (DATAFILE A)
>>
>> DATAFILE B
>>
>> +------------------------+
>> doa date3
>> ------------------------
>> 1. 23-05-2012 .
>> 2. 03-11-2011 11mar2011
>> 3. 02-09-2010 09feb2010
>> 4. 01-07-2010 07jan2010
>> 5. 18-04-2012 .
>> +------------------------+
>>
>> The problem is both datafiles use different format of date, the former
>> uses numeric and the latter uses str. My questions would be
>> 1) what is the best way to work around appending this two datafiles
>> 2) i have converted the 'doa' in the latter file (DATAFILE B) using
>>
>> generate date3=date(doa,"MDY")
>> format date3 %d
>>
>> but only obs from 2 to 4 were converted but obs 1 and 5 were not.
>>
>> Really appreciate if someone can help me with these 2 questions.
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/faqs/resources/statalist-faq/
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/