I have used the compute function successfully many times to add up variables for a sum. I have data that originated from Qualtrics, moved into SPSS with string variables. Used automatic recode to change the variables to the numeric format. These are dependent observations with 21 participants. Recoded to account for reverse scoring. Tried adding these 37 "pre" variables up to get a totalpre score and the same for 37 "post" variables to get a totalpost score. Variables are measured as 1 for correct answer and 0 for incorrect. There is some missing data within the 74 variables but the totals come up with ALL missing data (no totals).  Any idea what I might be doing wrong here?

------------------------------
Barbara Niedz
------------------------------

#SPSSStatistics

Hi. Any chance you could share your data or at least the syntax, so I could see what's going on?

I assume that you got no warnings when you ran it....?

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Thu March 10, 2022 10:23 AM
From: Barbara Niedz
Subject: Problems with compute

I have used the compute function successfully many times to add up variables for a sum. I have data that originated from Qualtrics, moved into SPSS with string variables. Used automatic recode to change the variables to the numeric format. These are dependent observations with 21 participants. Recoded to account for reverse scoring. Tried adding these 37 "pre" variables up to get a totalpre score and the same for 37 "post" variables to get a totalpost score. Variables are measured as 1 for correct answer and 0 for incorrect. There is some missing data within the 74 variables but the totals come up with ALL missing data (no totals).  Any idea what I might be doing wrong here?

------------------------------
Barbara Niedz
------------------------------

#SPSSStatistics

Original Message:
Sent: 3/10/2022 11:18:00 AM
From: Rick Marcantonio
Subject: RE: Problems with compute

Hi. Any chance you could share your data or at least the syntax, so I could see what's going on?

I assume that you got no warnings when you ran it....?

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Thu March 10, 2022 10:23 AM
From: Barbara Niedz
Subject: Problems with compute

I have used the compute function successfully many times to add up variables for a sum. I have data that originated from Qualtrics, moved into SPSS with string variables. Used automatic recode to change the variables to the numeric format. These are dependent observations with 21 participants. Recoded to account for reverse scoring. Tried adding these 37 "pre" variables up to get a totalpre score and the same for 37 "post" variables to get a totalpost score. Variables are measured as 1 for correct answer and 0 for incorrect. There is some missing data within the 74 variables but the totals come up with ALL missing data (no totals).  Any idea what I might be doing wrong here?

------------------------------
Barbara Niedz
------------------------------

#SPSSStatistics

Are you using the SUM function or addition using the "+" sign? Addition using the "+" sign will result in a missing value if any of the values you are summing together are missing. See this support page for more detail.

------------------------------
Brian Joy
------------------------------

Original Message:
Sent: Thu March 10, 2022 10:23 AM
From: Barbara Niedz
Subject: Problems with compute

I have used the compute function successfully many times to add up variables for a sum. I have data that originated from Qualtrics, moved into SPSS with string variables. Used automatic recode to change the variables to the numeric format. These are dependent observations with 21 participants. Recoded to account for reverse scoring. Tried adding these 37 "pre" variables up to get a totalpre score and the same for 37 "post" variables to get a totalpost score. Variables are measured as 1 for correct answer and 0 for incorrect. There is some missing data within the 74 variables but the totals come up with ALL missing data (no totals).  Any idea what I might be doing wrong here?

------------------------------
Barbara Niedz
------------------------------

#SPSSStatistics