Mutually exclusive cases

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Mutually exclusive cases

Nogitsune
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Mutually exclusive cases

bdates
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Mutually exclusive cases

Nogitsune
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Mutually exclusive cases

David Marso
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?"
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Mutually exclusive cases

Jon Peck
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]

===================== 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Mutually exclusive cases

Mark Miller
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

===================== 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Mutually exclusive cases

Mark Miller
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


===================== 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Mutually exclusive cases

John F Hall

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

 

 

===================== 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Mutually exclusive cases

Ives, Melissa L
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
Loading...