Identifying cases with the same values across all variables

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Identifying cases with the same values across all variables

Johnny Amora
Hi all,
My database consists of 225 variables and 223 cases.  How to identify the cases with the same values across all the variables.
 
Thank you.
Johnny


      Connect instantly with more friends on your blog and personal website? Create your latest Pingbox today! http://ph.messenger.yahoo.com/pingbox

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

Re: Identifying cases with the same values across all variables

ViAnn Beadle
Data>Identify Duplicate Cases...

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Johnny Amora
Sent: Wednesday, January 28, 2009 8:24 AM
To: [hidden email]
Subject: Identifying cases with the same values across all variables

Hi all,
My database consists of 225 variables and 223 cases.  How to identify the cases with the same values across all the variables.

Thank you.
Johnny


      Connect instantly with more friends on your blog and personal website? Create your latest Pingbox today! http://ph.messenger.yahoo.com/pingbox

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

Re: Identifying cases with the same values across all variables

Johnny Amora
Thanks a lot, ViAnn.

--- On Wed, 1/28/09, ViAnn Beadle <[hidden email]> wrote:

From: ViAnn Beadle <[hidden email]>
Subject: Re: Identifying cases with the same values across all variables
To: [hidden email]
Date: Wednesday, 28 January, 2009, 11:51 PM

Data>Identify Duplicate Cases...

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Johnny
Amora
Sent: Wednesday, January 28, 2009 8:24 AM
To: [hidden email]
Subject: Identifying cases with the same values across all variables

Hi all,
My database consists of 225 variables and 223 cases.  How to identify the cases
with the same values across all the variables.

Thank you.
Johnny


      Connect instantly with more friends on your blog and personal website?
Create your latest Pingbox today! http://ph.messenger.yahoo.com/pingbox

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



      Adding more friends is quick and easy.&lt;/a&gt;&lt;br&gt;Import them over to Yahoo! Mail today! http://www.trueswitch.com/yahoo-ph

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

Re: Identifying cases with the same values across all variables

Albert-Jan Roskam
In reply to this post by ViAnn Beadle
But isn't IDC about cross-CASE comparisons, as the name suggests? I thought the OP wanted a cross-variable comparison?
Or maybe I misunderstood. Anyway, a cross-var comparison can be done like this:

set mprint = on.
begin program.
import spss, spssaux
varDict = spssaux.VariableDict()
firstvar = spssaux.GetVariableNamesList()[0]
spss.Submit("compute n_diff = 0.")
for var in varDict:
        spss.Submit("if ( %s ne %s ) n_diff  = n_diff + 1." % (var.VariableName, firstvar))
spss.Submit("""variable label n_same 'number of different values'.
value labels n_diff 0 'all values are the same'.
fre n_diff.""")
end program.

Cheers!!
Albert-Jan


----- Original Message ----
From: ViAnn Beadle <[hidden email]>
To: [hidden email]
Sent: Wednesday, January 28, 2009 4:51:51 PM
Subject: Re: Identifying cases with the same values across all variables

Data>Identify Duplicate Cases...

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Johnny Amora
Sent: Wednesday, January 28, 2009 8:24 AM
To: [hidden email]
Subject: Identifying cases with the same values across all variables

Hi all,
My database consists of 225 variables and 223 cases.  How to identify the cases with the same values across all the variables.

Thank you.
Johnny


      Connect instantly with more friends on your blog and personal website? Create your latest Pingbox today! http://ph.messenger.yahoo.com/pingbox

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