How can I calculate the number of cases in SPSS?

Question

Each column shows the types of tools used. The last column shows how many tools are used.

I would like to calculate the last column with SPSS without turning the columns into 1.

score 5 · Answer 1 · answered Jan 22 '15 at 15:04

5

You can use the COUNT command to do this, small example below.

DATA LIST FREE / Tool1 Tool2 Tool3.
BEGIN DATA
1 3 8
1 5 1
1 . .
2 3 .
3 . .
END DATA.

COUNT Tool# = Tool1 TO Tool3 (LOWEST THRU HIGHEST).
EXECUTE.

answered Jan 22 '15 at 15:04

Andy W

3

Or use `compute Tool# = nvalid(Tool1 TO Tool3)`. – ttnphns Jan 22 '15 at 18:32

1 Answers1