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: RE: Question: date format
From
Sergiy Radyakin <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: RE: Question: date format
Date
Fri, 13 Sep 2013 14:22:26 +0100
On Thu, Sep 12, 2013 at 2:19 PM, Joe Canner <[email protected]> wrote:
> Thomas,
>
> I don't see anything in the documentation about displaying a Stata datetime variable as just a time. Generally speaking, times without dates are kind of useless, which is probably why they didn't provide for this.
Joe, this is perfectly doable with a custom format:
set obs 10
generate x=1000*_n
format x %tcHH:MM:SS
list
If you want, you can have a format, which displays, e.g. seconds only
(format x %tcSS). Whether that makes sense or not, depends on the
context.
Best, Sergiy Radyakin
>
> I would suggest you combine the date variable and the time variable into one datetime variable. Say your original date variable is -date1- and your time variable is -time1-:
>
> . gen datetime1=cofd(date1)+time1
>
> -cofd()- converts your date to a datetime with midnight as the time. Your time variable is the number of milliseconds past midnight. So, the sum should be a legitimate datetime variable.
>
> Later, if you need information on just the time you can extract it using the hh(), mm(), and ss() functions.
>
> Regards,
> Joe Canner
> Johns Hopkins University School of Medicine
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Bourveau
> Sent: Thursday, September 12, 2013 8:40 AM
> To: [email protected]
> Subject: st: Question: date format
>
> Dear Statalist members,
>
> I obtained data on the timing of some announcements made by firms. For each event, I have two different variables: one variable for the date, and another one for the hours, minutes and seconds of the timing.
>
> However, when I obtained the second variable, it looks like this:
>
> 01jan1960 13:57:54
> 01jan1960 23:17:48
> 01jan1960 08:32:52
>
> Specifically, for each line, "01jan1960" is written before each hours, which was not supposed to be.
>
> The variable is in a long format (%tcHH:MM:SS) and I don't know how to drop the "01jan1960" for each line.
>
> If anyone has a suggestion, that would be nice.
>
> Thanks a in advance
> Best,
> Thomas
>
> --
> Thomas Bourveau
> [email protected]
> 0637573925
> *
> * 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/
*
* 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/