Dear all,
I am processing hourly time series data (DD.MM.YYYY hh:mm), where the date variable is formatted as a string and looks the following:
. list datestring
datestring
1. 01.04.2018 00:00
2. 01.04.2018 01:00
3. 01.04.2018 02:00
4. 01.04.2018 03:00
5. 01.04.2018 04:00
To convert the string variable into a date variable, I run the following code:
gen Datetime = clock(datestring, "DMYhm")
format Datetime %tc
This is what I get:
. list Datetime datestring
+---------------------------------------+
| Datetime datestring |
|---------------------------------------|
1. | 01apr2018 00:00:19 01.04.2018 00:00 |
2. | 01apr2018 00:59:18 01.04.2018 01:00 |
3. | 01apr2018 02:00:28 01.04.2018 02:00 |
4. | 01apr2018 02:59:27 01.04.2018 03:00 |
5. | 01apr2018 04:00:37 01.04.2018 04:00 |
+---------------------------------------+
However, "Datetime" and "datestring" are not equivalent. For example, in row 2 the clock time is 00:59:18, whereas it should be 00:01:00.
I believe that this "mismatch" stems from the missing seconds in the variable "datestring", but I do not know how to fix this. Any help would be much appreciated!
Many thanks in advance!
Mario
Related Posts with Mismatch between date formatted as string and numeric date
Filling in missing data from previous values?Below I have included an example of a wide dataset in which children have ages reported at each wave…
Table1 command issueHello, when I write this command: table1, by (pes) vars(edad conts \ par_cat cat \ hta cat \ preprev…
Interpreting Log transformed ITSA modelThis question might not be so much as a programming question as an interpretation question. I have …
Why line, bar, and pie plot dominate publicationsDear Stata users, There are so many plot types in statistical world, line, bar, pie, box, histogram…
Regression output featuring a period for one variableI'm using logit regression to link state-level policies with an individual's probability of reemploy…
Subscribe to:
Post Comments (Atom)
0 Response to Mismatch between date formatted as string and numeric date
Post a Comment