Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Divide the time in equal intervals


From   Beatrice Crozza <beatrice.crozza@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Divide the time in equal intervals
Date   Thu, 12 Nov 2009 16:15:52 +0000

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index