multiple response recoding and how to use it in analysis

[Leslie-26]

Thanks in advance for your help.  The survey database has seven variables
for ethnicity (0,1) for African American, Asian, Hispanice, White, Native
American, Multiracial, and Other.  I want to recode these seven into one
variable with four options:  Af-Am, H, W, Other.  I've borrowed code and
tried to modify it. The code and table output are below, followed by my
question.

CODE:

RECODE S2Q1013_1 (1= 1)(else=0) INTO q38_1MR.
RECODE S2Q1013_2 (1= 4)(else=0) INTO q38_2MR.
RECODE S2Q1013_3 (1= 2)(else=0) INTO q38_3MR.
RECODE S2Q1013_4 (1= 3)(else=0) INTO q38_4MR.
RECODE S2Q1013_5 (1= 4)(else=0) INTO q38_5MR.
RECODE S2Q1013_6 (1= 4)(else=0) INTO q38_6MR.
RECODE S2Q1013_7 (1= 4)(else=0) INTO q38_7MR.
EXECUTE.
VALUE LABEL q38_1MR to q38_7MR 1 'African'
                       2 'Hispanic'
  3 'Caucasian'
  4 'Other'.
MULT RESPONSE
  GROUPS=$q38 'Ethnicity' (q38_1MR q38_2MR q38_3MR q38_4MR q38_5MR q38_6MR
q38_7MR (1,7))
  /FREQUENCIES=$q38 .
EXECUTE.


OUTPUT
$q38 Frequencies
    Responses Percent of Cases
  N Percent
Ethnicity(a)
African 542 26.2% 27.8%
Hispanic 295 14.3% 15.1%
Caucasian 934 45.1% 47.8%
Other         298 14.4% 15.3%
Total  2069 100.0% 106.0%


QUESTIONS:

1.  It seems to give the correct output. But, are my modifications correct?
If not, what needs to change, why?

2.  I want to use this new ETHNICITY variable, $q38, in analysis, but the
variable does not show up on the list in the dataview.  How can I use this
variable?  What am I missing?

Leslie

[Judith Saebel]

I'd do this:

If S2Q1013_1 eq 1 ethn = 1.
If S2Q1013_3 eq 1 ethn = 2.
If S2Q1013_4 eq 1 ethn = 3.
If (S2Q1013_2 eq 1) or (S2Q1013_5 eq 1) or (S2Q1013_6 eq 1) or
   (S2Q1013_7 eq 1) ethn = 4.

I'm assuming that your respondents could fall into only one of the 7
possible categories.

HTH,


Judith
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Leslie
Sent: Thursday, 9 August 2007 10:11
To: [hidden email]
Subject: multiple response recoding and how to use it in analysis

Thanks in advance for your help.  The survey database has seven
variables
for ethnicity (0,1) for African American, Asian, Hispanice, White,
Native
American, Multiracial, and Other.  I want to recode these seven into one
variable with four options:  Af-Am, H, W, Other.  I've borrowed code and
tried to modify it. The code and table output are below, followed by my
question.

CODE:

RECODE S2Q1013_1 (1= 1)(else=0) INTO q38_1MR.
RECODE S2Q1013_2 (1= 4)(else=0) INTO q38_2MR.
RECODE S2Q1013_3 (1= 2)(else=0) INTO q38_3MR.
RECODE S2Q1013_4 (1= 3)(else=0) INTO q38_4MR.
RECODE S2Q1013_5 (1= 4)(else=0) INTO q38_5MR.
RECODE S2Q1013_6 (1= 4)(else=0) INTO q38_6MR.
RECODE S2Q1013_7 (1= 4)(else=0) INTO q38_7MR.
EXECUTE.
VALUE LABEL q38_1MR to q38_7MR 1 'African'
                       2 'Hispanic'
  3 'Caucasian'
  4 'Other'.
MULT RESPONSE
  GROUPS=$q38 'Ethnicity' (q38_1MR q38_2MR q38_3MR q38_4MR q38_5MR
q38_6MR
q38_7MR (1,7))
  /FREQUENCIES=$q38 .
EXECUTE.


OUTPUT
$q38 Frequencies
    Responses Percent of Cases
  N Percent
Ethnicity(a)
African 542 26.2% 27.8%
Hispanic 295 14.3% 15.1%
Caucasian 934 45.1% 47.8%
Other         298 14.4% 15.3%
Total  2069 100.0% 106.0%


QUESTIONS:

1.  It seems to give the correct output. But, are my modifications
correct?
If not, what needs to change, why?

2.  I want to use this new ETHNICITY variable, $q38, in analysis, but
the
variable does not show up on the list in the dataview.  How can I use
this
variable?  What am I missing?

Leslie

[Melissa Ives]

Generally if you have multiple dichotomies for race, there are some
folks who will select more than one.  You need to decide how you want to
handle these folks. It looks like you want to get a percent of any
mention of a particular race. (In the syntax below, if the person was
S2Q1013_1 and S2Q1013_3--s/he would end up coded only 2.

What we do is calculate a count of the dichotomies (count(S2Q1013_1 to
S2Q1013_7)) then if the count value is 1, code the race groups you want
and for count>1, code Mixed.  You may not want to do this.

We have also created versions for several only, mixed, other.  For
example: African American Only, African American mixed, Caucasian,
Hispanic, Other.  (AA Only is where AA is endorsed and the count is 1,
AA Mixed is where AA is endorsed and the count is >1.)

Your logic seems right to me, but I don't know of a way to retain a MR
groups variable in the dataset (for the mixed folks, what would the
value be?).  I would check the SPSS syntax help--in the
Overview-Limitations (or Operations, or subcommands) for more about how
MR works and what can be done.

Melissa

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Judith Saebel
Sent: Wednesday, August 08, 2007 8:34 PM
To: [hidden email]
Subject: Re: [SPSSX-L] multiple response recoding and how to use it in
analysis

I'd do this:

If S2Q1013_1 eq 1 ethn = 1.
If S2Q1013_3 eq 1 ethn = 2.
If S2Q1013_4 eq 1 ethn = 3.
If (S2Q1013_2 eq 1) or (S2Q1013_5 eq 1) or (S2Q1013_6 eq 1) or
   (S2Q1013_7 eq 1) ethn = 4.

I'm assuming that your respondents could fall into only one of the 7
possible categories.

HTH,


Judith
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Leslie
Sent: Thursday, 9 August 2007 10:11
To: [hidden email]
Subject: multiple response recoding and how to use it in analysis

Thanks in advance for your help.  The survey database has seven
variables for ethnicity (0,1) for African American, Asian, Hispanice,
White, Native American, Multiracial, and Other.  I want to recode these
seven into one variable with four options:  Af-Am, H, W, Other.  I've
borrowed code and tried to modify it. The code and table output are
below, followed by my question.

CODE:

RECODE S2Q1013_1 (1= 1)(else=0) INTO q38_1MR.
RECODE S2Q1013_2 (1= 4)(else=0) INTO q38_2MR.
RECODE S2Q1013_3 (1= 2)(else=0) INTO q38_3MR.
RECODE S2Q1013_4 (1= 3)(else=0) INTO q38_4MR.
RECODE S2Q1013_5 (1= 4)(else=0) INTO q38_5MR.
RECODE S2Q1013_6 (1= 4)(else=0) INTO q38_6MR.
RECODE S2Q1013_7 (1= 4)(else=0) INTO q38_7MR.
EXECUTE.
VALUE LABEL q38_1MR to q38_7MR 1 'African'
                       2 'Hispanic'
  3 'Caucasian'
  4 'Other'.
MULT RESPONSE
  GROUPS=$q38 'Ethnicity' (q38_1MR q38_2MR q38_3MR q38_4MR q38_5MR
q38_6MR q38_7MR (1,7))
  /FREQUENCIES=$q38 .
EXECUTE.


OUTPUT
$q38 Frequencies
    Responses Percent of Cases
  N Percent
Ethnicity(a)
African 542 26.2% 27.8%
Hispanic 295 14.3% 15.1%
Caucasian 934 45.1% 47.8%
Other         298 14.4% 15.3%
Total  2069 100.0% 106.0%


QUESTIONS:

1.  It seems to give the correct output. But, are my modifications
correct?
If not, what needs to change, why?

2.  I want to use this new ETHNICITY variable, $q38, in analysis, but
the variable does not show up on the list in the dataview.  How can I
use this variable?  What am I missing?

Leslie


PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

[Ornelas, Fermin]

I think you forgot to define the new variable before the recode
statement. It could be something like:
NUMERIC q38_1MR (F1.0)

But there are more people that know about this spss thing than me.

Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
1789 W. Jefferson Street
Phoenix, AZ 85032
Tel: [phone]
E-mail: [hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Leslie
Sent: Wednesday, August 08, 2007 5:41 PM
To: [hidden email]
Subject: multiple response recoding and how to use it in analysis

Thanks in advance for your help.  The survey database has seven
variables
for ethnicity (0,1) for African American, Asian, Hispanice, White,
Native
American, Multiracial, and Other.  I want to recode these seven into one
variable with four options:  Af-Am, H, W, Other.  I've borrowed code and
tried to modify it. The code and table output are below, followed by my
question.

CODE:

RECODE S2Q1013_1 (1= 1)(else=0) INTO q38_1MR.
RECODE S2Q1013_2 (1= 4)(else=0) INTO q38_2MR.
RECODE S2Q1013_3 (1= 2)(else=0) INTO q38_3MR.
RECODE S2Q1013_4 (1= 3)(else=0) INTO q38_4MR.
RECODE S2Q1013_5 (1= 4)(else=0) INTO q38_5MR.
RECODE S2Q1013_6 (1= 4)(else=0) INTO q38_6MR.
RECODE S2Q1013_7 (1= 4)(else=0) INTO q38_7MR.
EXECUTE.
VALUE LABEL q38_1MR to q38_7MR 1 'African'
                       2 'Hispanic'
  3 'Caucasian'
  4 'Other'.
MULT RESPONSE
  GROUPS=$q38 'Ethnicity' (q38_1MR q38_2MR q38_3MR q38_4MR q38_5MR
q38_6MR
q38_7MR (1,7))
  /FREQUENCIES=$q38 .
EXECUTE.


OUTPUT
$q38 Frequencies
    Responses Percent of Cases
  N Percent
Ethnicity(a)
African 542 26.2% 27.8%
Hispanic 295 14.3% 15.1%
Caucasian 934 45.1% 47.8%
Other         298 14.4% 15.3%
Total  2069 100.0% 106.0%


QUESTIONS:

1.  It seems to give the correct output. But, are my modifications
correct?
If not, what needs to change, why?

2.  I want to use this new ETHNICITY variable, $q38, in analysis, but
the
variable does not show up on the list in the dataview.  How can I use
this
variable?  What am I missing?

Leslie

NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR
CONFIDENTIAL information and is intended only for the use of the
specific
individual(s) to whom it is addressed.  It may contain information that
is
privileged and confidential under state and federal law.  This
information
may be used or disclosed only in accordance with law, and you may be
subject to penalties under law for improper use or further disclosure of

the information in this e-mail and its attachments. If you have received

this e-mail in error, please immediately notify the person named above
by
reply e-mail, and then delete the original e-mail.  Thank you.