|
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 |
|
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 |
|
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.</a><br>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 |
|
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 |
| Free forum by Nabble | Edit this page |
