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
Compute a difference rate between two variablesHello everyone, I have to use the variables lonely and ca_couple, calculate the proportions of indi…
Endogeneity concernsI am working with a dataset of about a total of 28000 observations for over a period of 10 years. I …
Perturb with MlogitHi All, I estimate a multinomial logit model with 10 independent variables. I suspect that there mi…
Different colors for graph barsHello, I have a basic doubt. I am trying to plot a graph on GDP per capita which has 2 bars- one fo…
Control variables for intraday data.Hi everyone, I would like to add control variables (BookToMarket, Size...) to my data to regress Abn…
Subscribe to:
Post Comments (Atom)
0 Response to Mismatch between date formatted as string and numeric date
Post a Comment