Calculating total scores from multiple variables

[bgreen]

Hello,

I'm hoping for some assistance with creating two variables (MetNeed
and UnmetNeed) which are derived form 25 other variables, for
simplicity sake called A-Y.  The total score for MetNeed is a count
of all values of 1, while the total score for UnmetNeed is the count
of all values of 2, from the variables A-Y.  For example, if case 1
has 15 1's, 9 2's and a 0, MetNeed would have a value of 15 and
UNmetNeed a value of 9.

  Any assistance regarding how to calculate the totals scores from
the variables  is appreciated .


Bob

=====================
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

[Maguin, Eugene]

The count command is your very good friend for your purpose. Be very aware of how missing data are processed by a count command, which is documented in the FM.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bob Green
Sent: Wednesday, January 22, 2014 2:29 AM
To: [hidden email]
Subject: Calculating total scores from multiple variables

Hello,

I'm hoping for some assistance with creating two variables (MetNeed and UnmetNeed) which are derived form 25 other variables, for simplicity sake called A-Y.  The total score for MetNeed is a count of all values of 1, while the total score for UnmetNeed is the count of all values of 2, from the variables A-Y.  For example, if case 1 has 15 1's, 9 2's and a 0, MetNeed would have a value of 15 and UNmetNeed a value of 9.

  Any assistance regarding how to calculate the totals scores from the variables  is appreciated .


Bob

=====================
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

=====================
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

[John F Hall]

OK, so you need:

File> New > syntax:

Then write:

count metneed = x to y (1)
        /unmetneed = x to y (2).
format metneed unmetneed (f2.0)
freq metneed unmetneed.

As Gene says, be careful of missing values as SPSS assigns a score even if
one or more items in the source varlist are missing.  What is your value 0?

To get round the missing values problem you can use:

count <newvar> = sum.25 (<varlist>)

. . but you'd need to be careful.  If you post an example of data you'll get
more appropriate help.


John F Hall (Mr)
[Retired academic survey researcher]

Email:   [hidden email]
Website: www.surveyresearch.weebly.com
SPSS start page:  www.surveyresearch.weebly.com/1-survey-analysis-workshop



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Maguin, Eugene
Sent: 22 January 2014 18:02
To: [hidden email]
Subject: Re: Calculating total scores from multiple variables

The count command is your very good friend for your purpose. Be very aware
of how missing data are processed by a count command, which is documented in
the FM.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bob
Green
Sent: Wednesday, January 22, 2014 2:29 AM
To: [hidden email]
Subject: Calculating total scores from multiple variables

Hello,

I'm hoping for some assistance with creating two variables (MetNeed and
UnmetNeed) which are derived form 25 other variables, for simplicity sake
called A-Y.  The total score for MetNeed is a count of all values of 1,
while the total score for UnmetNeed is the count of all values of 2, from
the variables A-Y.  For example, if case 1 has 15 1's, 9 2's and a 0,
MetNeed would have a value of 15 and UNmetNeed a value of 9.

  Any assistance regarding how to calculate the totals scores from the
variables  is appreciated .


Bob

=====================
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

=====================
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

=====================
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