Date:         Tue, 29 Apr 2008 16:21:42 -0400
Reply-To:     Joanne Tsai <jtsai@targetrx.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Joanne Tsai <jtsai@targetrx.com>
Subject:      loop function for integral or summation?
Content-Type: text/plain; charset="us-ascii"

Dear colisters:

I was advised to explain my question a little bit further. I apologize
for the confusion.  

What I have on my current data set is from column Market to A2, and I'd
like to generate a column A11 respond to A1, and A22 respond to A2. Time
is my dependent variable which I'd like to take integral of. For
example, for row 6, time at 4, A11 should calculate A1 (t=0) + A1 (t=1)
+A1 (t=2) +A1 (t=3)+ A1 (t=4), which is equivalent to the summation of
A1 from time 0 to time 4. 

Is the loop function the right direction? 

Thank you again for your help. 

 

MARKET

PROD

time

A1

A2

A11

A22

A

B

0

0

0

0

0

A

B

1

0.00024

0.00001

0.00024

0.00001

A

B

2

0.00059

0.00001

0.00084

0.00002

A

B

3

0.00128

0.00005

0.00212

0.00006

A

B

4

0.00198

0.00009

0.0041

0.00015

A

B

5

0.00286

0.00015

0.00696

0.0003

A

B

6

0.00364

0.00022

0.0106

0.00052

A

B

7

0.00441

0.00029

0.01501

0.00082

A

B

8

0.00531

0.00039

0.02032

0.0012

A

B

9

0.00621

0.00049

0.02653

0.00169

 

 

 

====================To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD