Loop through items and sum items

[huang jialin]

Hi,

I have two sets of variables called ITEM 1 to ITEM 47, and another called L1 to L47. What I want to do is to calculate the sum of Ls if any ITEM#i=1. What I wrote is as following:
LOOP
       #i=1 to 47.
       COMPUTE LSUM=0.
       IF (ITEM(#i)=1) LSUM=LSUM+L(#i).
END LOOP.

But I got an error message saying the characters do not match any existing function or vector. What should I do then? Your inputs will be very appreciated.

Thanks.

Sincerely,
Jialin Huang

[Art Kendall]

try this untested approach.
numeric Lsum Lcount (f2).
compute Lsum = 0.
compute Lcount = 0.
do repeat item = item1 to item 47
� /L = L1 to L47.
do if item eq 1.
compute lcount = lcount+1
compute lsum = lsum +L.
end repeat.

when you use the LOOP approach L and Item should be Vectors.� � The presetting to zero should be outside the loop.
On 10/3/2012 10:39 AM, huang jialin wrote:

Hi,

I have two sets of variables called ITEM 1 to ITEM 47, and another called L1 to L47. What I want to do is to calculate the sum of Ls if any ITEM#i=1. What I wrote is as following:
LOOP
� � � � � #i=1 to 47.
� � � � � COMPUTE LSUM=0.
� � � � � � IF (ITEM(#i)=1) LSUM=LSUM+L(#i).
END LOOP.

But I got an error message saying the characters do not match any existing function or vector. What should I do then? Your inputs will be very appreciated.

Thanks.

Sincerely,
Jialin Huang

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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

[David Marso]

You have not declared your vectors.
You also want to initialize LSUM outside of the loop.

huang jialin wrote

Hi,

I have two sets of variables called ITEM 1 to ITEM 47, and another called
L1 to L47. What I want to do is to calculate the sum of Ls if any ITEM#i=1.
What I wrote is as following:
LOOP
       #i=1 to 47.
       COMPUTE LSUM=0.
       IF (ITEM(#i)=1) LSUM=LSUM+L(#i).
END LOOP.

But I got an error message saying the characters do not match any existing
function or vector. What should I do then? Your inputs will be very
appreciated.

Thanks.

Sincerely,
Jialin Huang

[Art Kendall]

Yes put "end if." before the "end repeat"
On 10/3/2012 11:06 AM, huang jialin wrote:

Art,

There are multiple warnings when I ran it. Also, should END IF be associated with DO IF in the syntax?

Thanks.

Jialin Huang

On Wed, Oct 3, 2012 at 9:59 AM, Art Kendall <[hidden email]> wrote:

try this untested approach.
numeric Lsum Lcount (f2).
compute Lsum = 0.
compute Lcount = 0.
do repeat item = item1 to item 47
� /L = L1 to L47.
do if item eq 1.
compute lcount = lcount+1
compute lsum = lsum +L.
end repeat.

when you use the LOOP approach L and Item should be Vectors.� � The presetting to zero should be outside the loop.

Art Kendall
Social Research Consultants

On 10/3/2012 10:39 AM, huang jialin wrote:

Hi,

I have two sets of variables called ITEM 1 to ITEM 47, and another called L1 to L47. What I want to do is to calculate the sum of Ls if any ITEM#i=1. What I wrote is as following:
LOOP
� � � � � #i=1 to 47.
� � � � � COMPUTE LSUM=0.
� � � � � � IF (ITEM(#i)=1) LSUM=LSUM+L(#i).
END LOOP.

But I got an error message saying the characters do not match any existing function or vector. What should I do then? Your inputs will be very appreciated.

Thanks.

Sincerely,
Jialin Huang

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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

[Art Kendall]

try this
* make up cases and items.
new file.
input program.
� � vector L (47,f1).
� � vector item (47,f2).
� � loop id = 1 to 25.
� � � � � loop #i = 1 to 47.
� � � � � � � � compute item(#i) = rv.bernoulli(.5).
� � � � � � � � compute l(#i) = rnd(rv.normal(50,10)).
� � � � � end loop.
� � � � � end case.
� � end loop.
� � end file.
end input program.
* do this with data once it is made up.
numeric Lsum Lcount (f2).
compute Lsum = 0.
compute Lcount = 0.
do repeat item = item1 to item47
� /L = L1 to L47.
do if item eq 1.
compute lcount = lcount+1.
compute lsum = lsum +L.
end if.
end repeat.
frequencies vars=� lsum lcount.

On 10/3/2012 12:38 PM, huang jialin wrote:

numeric Lsum Lcount (f2).
compute Lsum = 0.
compute Lcount = 0.
do repeat item = item1 to item 47
� /L = L1 to L47.
do if item eq 1.
compute lcount = lcount+1
compute lsum = lsum +L.
end repeat.

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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