# st: RE: RE: Re: sum across observations until a certain cutpoint

 From "Amanda Botticello" To Subject st: RE: RE: Re: sum across observations until a certain cutpoint Date Sun, 09 Nov 2008 13:20:24 -0500

```I want to calculate how many items each subject completed within 60 seconds. And I can't do anything about the data structure, unfortunately.

Amanda L. Botticello, PhD, MPH
Outcomes Research Scientist
Kessler Medical Rehabilitation Research and Education Center
Assistant Professor
Department of Physical Medicine & Rehabilitation
UMDNJ-New Jersey Medical School

1199 Pleasant Valley Way
West Orange, NJ  07052
phone: (973)243-6973
email: abotticello@kmrrec.org

>>> "Nick Cox" <n.j.cox@durham.ac.uk> 11/9/2008 1:14 PM >>>
You've lost me. I don't understand how your data structure copes with
time spent on failed tasks.

Please be clear: Do you want to cumulate times and see how many tasks in
total were completed within a total of 60 seconds, as implied by your
original question, or do you just want to count how many tasks were
individually completed within 60 seconds?

Incidentally, I think you would be better off reshaping this to long.

Nick
n.j.cox@durham.ac.uk

Amanda Botticello

The data is more like this:

id  item1  time1    item2  time2  itmem3 time3
1    1         2           1         3        1          2
2    1         5           0         0        0          0
3    1         3           1         3        1          5

The variable "item" is coded 0,1, where 1 indicates the item was
completed
Time is recorded in number of seconds to complete.  If they didn't
complete an item, the time is 0

>>> "Nick Cox" <n.j.cox@durham.ac.uk> 11/9/2008 12:59 PM >>>
Still not very clear to me, but I guess something like this

20      10    20    5       10
5       10    15    30      2
100     2      3    3       4

So that the three individuals above had completed 4, 4, 0 tasks in the
first 60 seconds.

How many within 60 seconds?

gen cumul = 0
gen within60 = 0

qui forval i = 1/5 {
replace cumul = cumul + task`i'
replace within60 = `i' if cumul <= 60
}

Nick
n.j.cox@durham.ac.uk

Amanda Botticello PhD, MPH

IT's a "wide" dataset...subjects completed up to 200 items in a task,
and we recorded the number of seconds it took to complete each item.  I
can create a sum of the total number of items completed and total time;
now I want to find out how many items each individual completed in 60,
90, and 120 seconds.  Does that help?

>>> "Martin Weiss" <martin.weiss1@gmx.de> 11/9/2008 11:00 AM >>>

Well, if you want the running sum, look at -help sum()-. But maybe you
could
give us a peek at your data structure, that would assist in answering
question...

"Amanda Botticello" <abotticello@kmrrec.org>

>I have a dataset of test items and the time (in seconds)to complete
each
>item.  I need to create a variable that sums the time variables up to a

>certain number -- i.e., 60, 90, 120 seconds.  Is there a way I can use
the
>egen newvar = rowtot (time*) command to count up to 60 seconds, etc?

*
*   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/

The information in this transmission is intended for official use of the Kessler Foundation.  It is intended for the exclusive use of the persons or entities to which it is addressed.  If you are not an intended recipient or the employee or agent responsible for delivering this transmission to an intended recipient, be aware that any disclosure, dissemination, distribution or copying of this communication, or the use of its contents, is strictly prohibited.  If you received this transmission in error, please notify the sender by return e-mail and delete the material from any computer.

*
*   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/
```