I have a lot of columns in SPSS and for a calculation, I need to get the sum of each and every one of them. Is there a way to do this in SPSS?
An example of what I mean is shown below:
age gender question 1 question 2
-------------------------------------------------
25 m 2 3
19 f 4 2
20 f 3 4
------- -------
need sum need sum
If you just need an ouput table with the results then see the DESCRIPTIVES command.
Alternatively, if you need the results in an output dataset for further processing then see the AGGREGATE command.