Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: appending date variable in 2 datafiles


From   Kamarul Imran <kim4597@gmail.com>
To   statalist@hsphsun2.harvard.edu
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

Kamarul



On Wed, Oct 17, 2012 at 12:10 PM, Nick Cox <njcoxstata@gmail.com> 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, Kamarul Imran <kim4597@gmail.com> 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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index