Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

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

From |
Rebecca Pope <rebecca.a.pope@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: summarizing data across rows (e.g as in time use files) |

Date |
Sat, 9 Mar 2013 22:17:50 -0600 |

If you want when the activity started, just add (min) starttime to the code that Nick already gave you. It isn't clear to me why you would want to keep the start time though if you are calculating duration for the whole activity since people could start & stop, then restart some time later. Perhaps you should also check out -tsspell- (by Nick Cox, available from SSC), which will divide your activities up into continuous blocks. Eg. if a person sleeps for 30 minutes in the afternoon and then goes to bed again in the evening and sleeps 6 hours, that would be treated as two different episodes & you could have the "starttime" for each. Regards, Rebecca On Sat, Mar 9, 2013 at 9:39 PM, Adeel Yousaf <townplanneradeel@gmail.com> wrote: > Thanks, its good but not good enough for the purpose. after performing > as u suggested, 'starttime' variable is lost, which reflects when > activity started. If i collapse by 'starttime', it does not totals > 'duration'. please share your thoughts, > > On Sat, Mar 9, 2013 at 4:36 PM, <njcoxstata@gmail.com> wrote: >> -help collapse- >> >> collapse (sum) duration, by(person code) >> >> or something similar. >> >> Sent from my iPad >> >> On 9 Mar 2013, at 03:54, Adeel Yousaf <townplanneradeel@gmail.com> wrote: >> >>> Hi, >>> >>> I have episode file of time use showing population's activity code and >>> duration. In this data, an activity longer than 30 mins (e.g. sleep) >>> has multiple episodes, that creates unrealistically larger number of >>> activities in one day. I want to keep one record per activity if the >>> code is repeated in next row and generate combine duration for that >>> activity. for example, code '11' has been repeated in three >>> episodes/rows, but it should be in one row with duration=90, how can i >>> do that! >>> >>> person starttime episode duration code >>> 1 11/25/2007 4:00 1 30 11 >>> 1 11/25/2007 4:30 2 30 11 >>> 1 11/25/2007 5:00 3 30 11 >>> 1 11/25/2007 5:30 4 15 30 >>> 1 11/25/2007 5:45 5 15 60 >>> 1 11/25/2007 6:00 6 30 60 >>> 1 11/25/2007 6:30 7 30 60 >>> 1 11/25/2007 7:00 8 15 413 >>> 1 11/25/2007 7:15 9 15 412 >>> 1 11/25/2007 7:30 10 30 412 >>> 1 11/25/2007 8:00 11 15 412 >>> 1 11/25/2007 8:15 12 15 20 >>> 1 11/25/2007 8:30 13 15 413 >>> 1 11/25/2007 8:45 14 15 413 >>> 1 11/25/2007 9:00 15 30 413 >>> >>> >> * >> * For searches and help try: >> * http://www.stata.com/help.cgi?search >> * http://www.stata.com/support/faqs/resources/statalist-faq/ >> * http://www.ats.ucla.edu/stat/stata/ > > > > -- > Muhammad Adeel > Room 841 A, ,8F. Knowles building > Department of Urban Planning and Design > The University of Hong Kong > Pokfulam road, Hong Kong SAR > Cell: 0085254894670 > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/faqs/resources/statalist-faq/ > * http://www.ats.ucla.edu/stat/stata/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**Re: st: summarizing data across rows (e.g as in time use files)***From:*Adeel Yousaf <townplanneradeel@gmail.com>

**References**:**st: summarizing data across rows (e.g as in time use files)***From:*Adeel Yousaf <townplanneradeel@gmail.com>

**Re: st: summarizing data across rows (e.g as in time use files)***From:*njcoxstata@gmail.com

**Re: st: summarizing data across rows (e.g as in time use files)***From:*Adeel Yousaf <townplanneradeel@gmail.com>

- Prev by Date:
**Re: st: summarizing data across rows (e.g as in time use files)** - Next by Date:
**st: index number of an observation** - Previous by thread:
**Re: st: summarizing data across rows (e.g as in time use files)** - Next by thread:
**Re: st: summarizing data across rows (e.g as in time use files)** - Index(es):