Dear all,
I have my database with 3 variables:
Date Time Quantity
12/04/2009 9:07:21 5
12/04/2009 10:10:21 10
12/04/2009 10:13:23 16
... ....
13/04/2009 10:12:54 3
.... ....
14/04/2009 13:20:56 13
I would like to divide the time in equal intervals of 5-min from
8:30:00 to 17:00:00 for each day.
If I use the function: egen newtime cut(time), at(...)
I have the result but of course in my newtime I will have only the
time that I already have in time, but equally intervalled.
Instead, I would like to have newtime for every 5-min intervals, this
means that I would like to have also 8:30:00 in my newtime with a
quantity of zero.
How can I reach this result?
Thank you very much.
Best,
Bea
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
