Hi. I have hourly level data with the format, "2010123123" representing "23:00 Dec 31, 2010". I can convert it into time variable by using "double" but there is a problem for some observations. The data show "00:00 Jan 1, 2011" as 2010123124 and Stata does not automatically change it to the midnight next day and generate an empty cell, shown as below. I would really appreciate it if you could help me to correctly convert it into the next day format. Thank you very much!
Array
Related Posts with Error in converting time (hourly) variable
Panel data - dropping all observations after a switchHi everyone, I have panel data below (just one id shown), it is sorted by id and date I want to be …
Generating a variable to count # of "ideal" in each category per observationDear all, I have three variables(idealFruitVeg ; idealfiber ; idealssbweek). Each variable can have…
How to replace inconsistent identity code with the majority identity within 6 years?I have 140,000 firms for 2010-2015. I want to check whether the industrial code (indcode) is consist…
Name variableHello, I have a dataset with a variable called "Country". I would like to know the code to know the…
Seeking a way to examine the sensitivity of one variable with respect to another (both a time series)Hi, this maybe a very rookie question, but many thanks for any help. I have a data like this Sta…
Subscribe to:
Post Comments (Atom)
0 Response to Error in converting time (hourly) variable
Post a Comment