SPSSX Discussion

Mutually exclusive cases

Classic

List

Threaded

9 messages Options

Nogitsune

Mutually exclusive cases

Good evening,

I have a dataset with numerous variables and cases. Two of the variables ask the same question: one asks whether or not the person has attempted to do something and the other asks if the person considered to do the same thing. I am trying to figure out how to see if the answers are mutually exclusive, i.e. whether or not the person who attempted the deed also considered it, so that I will be able to identify those cases and report their quantity separately. Is there a way to do that without manually going through the cases?

Thank you!

Best,

Kseniya.

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

bdates

Re: Mutually exclusive cases

I'm not sure that the two are the same question. One asks about contemplation; the other asks about action. I work in the mental health area, and in screening for suicidal risk, these are two very distinct questions. "Have you ever thought about committing suicide?" "Have you ever attempted suicide?" There's even an in-between..."Do you have a plan for committing suicide?" I'm not sure what your topic is, but ideation and action are two separate issues. So, in the end you may not have to discriminate between the two at all.

Brian

From: SPSSX(r) Discussion [[hidden email]] on behalf of Kseniya Katsman [[hidden email]]
Sent: Tuesday, February 21, 2017 5:59 PM
To: [hidden email]
Subject: Mutually exclusive cases

Good evening,

Thank you!

Best,

Kseniya.

Nogitsune

Re: Mutually exclusive cases

Hi Brian,

Thank you for your input! They are not the same question, and I would like to have separate data on how many people attempted but not considered, how many people considered but not attempted, and how many attempted and considered.

Best,

Kseniya.

On Tue, Feb 21, 2017 at 6:16 PM, Dates, Brian <[hidden email]> wrote:

I'm not sure that the two are the same question. One asks about contemplation; the other asks about action. I work in the mental health area, and in screening for suicidal risk, these are two very distinct questions. "Have you ever thought about committing suicide?" "Have you ever attempted suicide?" There's even an in-between..."Do you have a plan for committing suicide?" I'm not sure what your topic is, but ideation and action are two separate issues. So, in the end you may not have to discriminate between the two at all.

Brian

From: SPSSX(r) Discussion [[hidden email]] on behalf of Kseniya Katsman [[hidden email]]
Sent: Tuesday, February 21, 2017 5:59 PM
To: [hidden email]
Subject: Mutually exclusive cases

Good evening,

I have a dataset with numerous variables and cases. Two of the variables ask the same question: one asks whether or not the person has attempted to do something and the other asks if the person considered to do the same thing. I am trying to figure out how to see if the answers are mutually exclusive, i.e. whether or not the person who attempted the deed also considered it, so that I will be able to identify those cases and report their quantity separately. Is there a way to do that without manually going through the cases?

Thank you!

Best,
Kseniya.

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

David Marso

Re: Mutually exclusive cases

Administrator

In reply to this post by Nogitsune

COMPUTE Same= (Q1 EQ Q2) .
OTOH, you DON'T specify what constitutes a consistent response between the questions so YMMV.

There is NEVER any good reason to "MANUALLY go through cases" if you have very basic SPSS syntax chops.
---

Kseniya Katsman wrote

Good evening,

I have a dataset with numerous variables and cases. Two of the variables
ask the same question: one asks whether or not the person has attempted to
do something and the other asks if the person considered to do the same
thing. I am trying to figure out how to see if the answers are mutually
exclusive, i.e. whether or not the person who attempted the deed also
considered it, so that I will be able to identify those cases and report
their quantity separately. Is there a way to do that without manually going
through the cases?

Thank you!

Best,
Kseniya.

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

Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"

Jon Peck

Re: Mutually exclusive cases

In reply to this post by Nogitsune

Run a crosstab of one against the other

On Tue, Feb 21, 2017 at 4:19 PM, Kseniya Katsman <[hidden email]> wrote:

Hi Brian,

Thank you for your input! They are not the same question, and I would like to have separate data on how many people attempted but not considered, how many people considered but not attempted, and how many attempted and considered.

Best,
Kseniya.

On Tue, Feb 21, 2017 at 6:16 PM, Dates, Brian <[hidden email]> wrote:

I'm not sure that the two are the same question. One asks about contemplation; the other asks about action. I work in the mental health area, and in screening for suicidal risk, these are two very distinct questions. "Have you ever thought about committing suicide?" "Have you ever attempted suicide?" There's even an in-between..."Do you have a plan for committing suicide?" I'm not sure what your topic is, but ideation and action are two separate issues. So, in the end you may not have to discriminate between the two at all.

Brian

From: SPSSX(r) Discussion [[hidden email]] on behalf of Kseniya Katsman [[hidden email]]
Sent: Tuesday, February 21, 2017 5:59 PM
To: [hidden email]
Subject: Mutually exclusive cases

Good evening,

I have a dataset with numerous variables and cases. Two of the variables ask the same question: one asks whether or not the person has attempted to do something and the other asks if the person considered to do the same thing. I am trying to figure out how to see if the answers are mutually exclusive, i.e. whether or not the person who attempted the deed also considered it, so that I will be able to identify those cases and report their quantity separately. Is there a way to do that without manually going through the cases?

Thank you!

Best,
Kseniya.

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

Jon K Peck
[hidden email]

Mark Miller

Re: Mutually exclusive cases

Compute a combo variable assuming response of interest =1

e.g Combo = (q1 eq 1) * 1 + (q2 eq 1) *2.

4 values -- 0 (neither)

1 ( Q! only)

2 (Q2 only)

4 ( BOTH)

-- Mark Miller

On Tue, Feb 21, 2017 at 4:22 PM, Jon Peck <[hidden email]> wrote:

Run a crosstab of one against the other

On Tue, Feb 21, 2017 at 4:19 PM, Kseniya Katsman <[hidden email]> wrote:
Hi Brian,

Thank you for your input! They are not the same question, and I would like to have separate data on how many people attempted but not considered, how many people considered but not attempted, and how many attempted and considered.

Best,
Kseniya.

On Tue, Feb 21, 2017 at 6:16 PM, Dates, Brian <[hidden email]> wrote:

I'm not sure that the two are the same question. One asks about contemplation; the other asks about action. I work in the mental health area, and in screening for suicidal risk, these are two very distinct questions. "Have you ever thought about committing suicide?" "Have you ever attempted suicide?" There's even an in-between..."Do you have a plan for committing suicide?" I'm not sure what your topic is, but ideation and action are two separate issues. So, in the end you may not have to discriminate between the two at all.

Brian

From: SPSSX(r) Discussion [[hidden email]] on behalf of Kseniya Katsman [[hidden email]]
Sent: Tuesday, February 21, 2017 5:59 PM
To: [hidden email]
Subject: Mutually exclusive cases

Good evening,

I have a dataset with numerous variables and cases. Two of the variables ask the same question: one asks whether or not the person has attempted to do something and the other asks if the person considered to do the same thing. I am trying to figure out how to see if the answers are mutually exclusive, i.e. whether or not the person who attempted the deed also considered it, so that I will be able to identify those cases and report their quantity separately. Is there a way to do that without manually going through the cases?

Thank you!

Best,
Kseniya.

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

--
Jon K Peck
[hidden email]

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

Mark Miller

Re: Mutually exclusive cases

Correction ... condition 4 has value3

On Tue, Feb 21, 2017 at 6:56 PM, Mark Miller <[hidden email]> wrote:

Compute a combo variable assuming response of interest =1
e.g Combo = (q1 eq 1) * 1 + (q2 eq 1) *2.

4 values -- 0 (neither)
1 ( Q! only)
2 (Q2 only)
4 ( BOTH)

-- Mark Miller

On Tue, Feb 21, 2017 at 4:22 PM, Jon Peck <[hidden email]> wrote:
Run a crosstab of one against the other

On Tue, Feb 21, 2017 at 4:19 PM, Kseniya Katsman <[hidden email]> wrote:
Hi Brian,

Thank you for your input! They are not the same question, and I would like to have separate data on how many people attempted but not considered, how many people considered but not attempted, and how many attempted and considered.

Best,
Kseniya.

On Tue, Feb 21, 2017 at 6:16 PM, Dates, Brian <[hidden email]> wrote:

I'm not sure that the two are the same question. One asks about contemplation; the other asks about action. I work in the mental health area, and in screening for suicidal risk, these are two very distinct questions. "Have you ever thought about committing suicide?" "Have you ever attempted suicide?" There's even an in-between..."Do you have a plan for committing suicide?" I'm not sure what your topic is, but ideation and action are two separate issues. So, in the end you may not have to discriminate between the two at all.

Brian

From: SPSSX(r) Discussion [[hidden email]] on behalf of Kseniya Katsman [[hidden email]]
Sent: Tuesday, February 21, 2017 5:59 PM
To: [hidden email]
Subject: Mutually exclusive cases

Good evening,

I have a dataset with numerous variables and cases. Two of the variables ask the same question: one asks whether or not the person has attempted to do something and the other asks if the person considered to do the same thing. I am trying to figure out how to see if the answers are mutually exclusive, i.e. whether or not the person who attempted the deed also considered it, so that I will be able to identify those cases and report their quantity separately. Is there a way to do that without manually going through the cases?

Thank you!

Best,
Kseniya.

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

--
Jon K Peck
[hidden email]

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

Re: Mutually exclusive cases

Mark has a stray ! in his syntax (leave shift key alone).

Jon’s suggestion of crosstabs is sound: I often use it to derive a single variable from two or more others. Assuming variables are v1 “Attempt” and v2 “Consider” with answers 1 = Yes and 2 = No:

compute v3 = v1*10 + v2.

recode v3 (11=1)(12=2)(21=3)(22=4)(else=-1).

formats v3 (f2.0).

missing values v3 (-1).

var lev v3 (ordinal).

var lab v3 ‘Attempt or consider’.

val lab v3

1 ‘Both attempted and considered’

2 ‘Attempted only’

3 ‘Considered only’

4 ‘Neither attempted nor considered’.

You can always reverse the coding so that the replies are in order of severity.

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

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mark Miller
Sent: 22 February 2017 03:58
To: [hidden email]
Subject: Re: Mutually exclusive cases

Correction ... condition 4 has value3

On Tue, Feb 21, 2017 at 6:56 PM, Mark Miller <[hidden email]> wrote:

Compute a combo variable assuming response of interest =1
e.g Combo = (q1 eq 1) * 1 + (q2 eq 1) *2.

4 values -- 0 (neither)
1 ( Q! only)
2 (Q2 only)
4 ( BOTH)

-- Mark Miller

On Tue, Feb 21, 2017 at 4:22 PM, Jon Peck <[hidden email]> wrote:
Run a crosstab of one against the other

On Tue, Feb 21, 2017 at 4:19 PM, Kseniya Katsman <[hidden email]> wrote:
Hi Brian,

Thank you for your input! They are not the same question, and I would like to have separate data on how many people attempted but not considered, how many people considered but not attempted, and how many attempted and considered.

Best,
Kseniya.

On Tue, Feb 21, 2017 at 6:16 PM, Dates, Brian <[hidden email]> wrote:
I'm not sure that the two are the same question. One asks about contemplation; the other asks about action. I work in the mental health area, and in screening for suicidal risk, these are two very distinct questions. "Have you ever thought about committing suicide?" "Have you ever attempted suicide?" There's even an in-between..."Do you have a plan for committing suicide?" I'm not sure what your topic is, but ideation and action are two separate issues. So, in the end you may not have to discriminate between the two at all.

Brian
From: SPSSX(r) Discussion [[hidden email]] on behalf of Kseniya Katsman [[hidden email]]
Sent: Tuesday, February 21, 2017 5:59 PM
To: [hidden email]
Subject: Mutually exclusive cases
Good evening,

I have a dataset with numerous variables and cases. Two of the variables ask the same question: one asks whether or not the person has attempted to do something and the other asks if the person considered to do the same thing. I am trying to figure out how to see if the answers are mutually exclusive, i.e. whether or not the person who attempted the deed also considered it, so that I will be able to identify those cases and report their quantity separately. Is there a way to do that without manually going through the cases?

Thank you!

Best,
Kseniya.
===================== 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

--
Jon K Peck
[hidden email]
===================== 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

MLIves

Re: Mutually exclusive cases

In reply to this post by David Marso

Kseniya,

They are not the same question.
e.g., Considering suicide is NOT the same as Attempting it.
Run a crosstab of considered by attempted.
Or create a new var: (if either are missing, no value for ConAtt will be created.)
If (sum(considered,attempted)=0) ConAtt=0. /*Neither
If (considered=1 and attempted=0 ConAtt=1. /*Considered only
If (considered=0 and attempted=1 ConAtt=2. /*Attempted only
If (sum(considered,attempted)=2) ConAtt=3. /*BOTH

Melissa

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Marso
Sent: Tuesday, February 21, 2017 7:13 PM
To: [hidden email]
Subject: Re: [SPSSX-L] Mutually exclusive cases

COMPUTE Same= (Q1 EQ Q2) .
OTOH, you DON'T specify what constitutes a consistent response between the questions so YMMV.

There is NEVER any good reason to "MANUALLY go through cases" if you have very basic SPSS syntax chops.
---

Kseniya Katsman wrote

> Good evening,
>
> I have a dataset with numerous variables and cases. Two of the
> variables ask the same question: one asks whether or not the person
> has attempted to do something and the other asks if the person
> considered to do the same thing. I am trying to figure out how to see
> if the answers are mutually exclusive, i.e. whether or not the person
> who attempted the deed also considered it, so that I will be able to
> identify those cases and report their quantity separately. Is there a
> way to do that without manually going through the cases?
>
> Thank you!
>
> Best,
> Kseniya.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

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

-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Mutually-exclusive-cases-tp5733856p5733859.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

________________________________

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

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