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: duplicated datetime variable differs from original datetime variable it was derived from
From
Milena Przheska <[email protected]>
To
[email protected]
Subject
Re: st: duplicated datetime variable differs from original datetime variable it was derived from
Date
Tue, 12 Nov 2013 13:01:26 +0100
The problem is that my time1 variable is double, and yet, when using
it in the model, it gives that error message
On Tue, Nov 12, 2013 at 12:54 PM, Nick Cox <[email protected]> wrote:
> Same answer. Use a -double-.
>
> Nick
> [email protected]
>
>
> On 12 November 2013 11:51, Milena Przheska
> <[email protected]> wrote:
>> When I try to fit a mixed effects model with the time1 variable as
>> defined above, I get an error message "time variable must be
>> integer-valued".
>>
>> I do need the time variable to be by the second, otherwise I will have
>> duplicate values for the time variable.
>>
>> If you have any suggestions, I would very much appreciate it.
>>
>> Thank you,
>> Milena
>>
>> On Tue, Nov 12, 2013 at 12:41 PM, Nick Cox <[email protected]> wrote:
>>> Phil has the answer in one. Unfortunately, you do have to keep
>>> remembering that a date-time to Stata is just an integer, usually
>>> large, giving time in milliseconds.
>>>
>>> . di %14.0f clock("07jun2012 03:11:48", "DMYhms")
>>> 1654657908000
>>>
>>> Numbers that big have to be stored as -double-s.
>>> Nick
>>> [email protected]
>>>
>>>
>>> On 12 November 2013 11:33, Phil Clayton <[email protected]> wrote:
>>>> Dates with times need to be stored in double precision. Try:
>>>> gen double time1=time
>>>>
>>>> See -help datetime-
>>>>
>>>> Phil
>>>>
>>>> On 12 Nov 2013, at 10:25 pm, Milena Przheska <[email protected]> wrote:
>>>>
>>>>> Dear Statalist members,
>>>>>
>>>>> When duplicating a time variable by typing
>>>>>
>>>>> gen time1 =time
>>>>>
>>>>> the new variable time1 is off by several seconds from the variable time, so
>>>>>
>>>>> time
>>>>> 06jun2012 22:44:51
>>>>> 06jun2012 22:44:54
>>>>> 06jun2012 22:44:56
>>>>> 07jun2012 01:39:58
>>>>> 07jun2012 01:40:05
>>>>> 07jun2012 01:40:45
>>>>> 07jun2012 03:09:48
>>>>> 07jun2012 03:09:48
>>>>> 07jun2012 03:11:06
>>>>>
>>>>> becomes
>>>>>
>>>>> time1
>>>>> 06jun2012 22:45:17
>>>>> 06jun2012 22:45:17
>>>>> 06jun2012 22:45:17
>>>>> 07jun2012 01:40:03
>>>>> 07jun2012 01:40:03
>>>>> 07jun2012 01:40:03
>>>>> 07jun2012 03:09:37
>>>>> 07jun2012 03:09:37
>>>>> 07jun2012 03:11:48
>>>>>
> *
> * 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/