Re: st: RE: Question on converting time-variable

[Simon Falck <sfalckstata@gmail.com>]

Nick,

As usual, you make a very good point. Yes, I need to add milliseconds to 
the time.

Thanks!

Best,
Simon

On 2013-10-01 16:52, Nick Cox wrote:
> The assumption here is that 2400 should be 0000, but otherwise the day
> is correct. If you think that the day should be the next day, you
> would need add
>
> 24 * 60 * 60 * 1000
>
> milliseconds to the time.
>
> Nick
> njcoxstata@gmail.com
>
>
> On 1 October 2013 10:32, Barclay Matthew (PUBLIC HEALTH ENGLAND)
> <matthewbarclay@nhs.net> wrote:
> > Hi Simon,
> >
> > One approach would be:
> >
> > // string containing first half of start variable
> > gen pre_start = substr(start,1,11)
> >
> > // string containing second half...
> > gen post_start = substr(start,-4,.)
> >
> > // replace "2400" with "0000"
> > replace post_start = "0000" if post_start == "2400"
> >
> > // recombine pre_ and post_start
> > egen new_start = concat(pre_start post_start)
> >
> > // generate starttime etc
> >
> > HTH,
> > Matt
> >
> > -----Original Message-----
> > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Simon Falck
> > Sent: 01 October 2013 09:55
> > To: statalist@hsphsun2.harvard.edu
> > Subject: st: Question on converting time-variable
> >
> > Dear Statalist,
> >
> > Working with Stata 11.2, I want to convert two string variables (start,
> > stop) with time information showing year-month-day-hour-minutes, e.g.
> > "1998 10 19 1000" to time-format so "01oct1998 10:00:00", which can
> > easily done by,
> >
> > gen double starttime=clock(start, "YMDhm")
> > format starttime %tc
> >
> > However, it appears that my timevariables (strings), i.e. the strings,
> > sometimes indicate midnight as 2400, e.g. "2004 12 13 2400" and sometime
> > as 0000, e.g. "1999 10 26 0000", and Stata seems only to accept the
> > latter, implying that observations that indicate midnight as "2400" are
> > not converted.
> >
> > My question how to convert observations that indicate midnight as 2400
> > to 0000 in the string variable(s), or to time variable(s)?
> *
> *   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/