Intraday date

[Eli Hadad]

2017-12-01 05:10:53
2017-12-01 05:10:57
2017-12-01 05:10:59
2017-12-01 05:11:00
2017-12-02 05:11:02

Hi, i have a file with date in the string format, as shown above and would like to transform in date and tsset it.
So far no luck, any help appreciated

[Marcos Almeida]

Please read the FAQ. There you'll find information about sharing data/output/command in the Stata Forum / Statalist.

Dealing with date and time in Stata really needs some exercise.

Luckily enough, you may start by typing - help datetime - in Stata's command window. There you'll find examples as well as the link to the Stata Manual.

To end, I recommend to take a look at several examples in this forum that may be help you, such as this one, recently posted.

Hopefully that helps.

[Nick Cox]

Marcos gives good advice as always. Just looking at your small example I see irregularly spaced times with gaps 4, 2, 1, 2 seconds. You could tsset using delta(1000) which would make your time units seconds, but it is hard to see how much that would help. In short, why do you think that tsset will help with irregular time series?