Date: Wed, 20 Jul 2011 13:55:19 +0100
Reply-To: joan casellas <joan.casellas@eu-survey.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: joan casellas <joan.casellas@eu-survey.com>
Subject: Re: Count of unique values across variables
In-Reply-To: <201107200226.p6JKFMSE021043@waikiki.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"
Have a look to the following link (is from David Marso):
http://www.spsstools.net/Syntax/MultipleResp/CountUniqueOccurencesOfAMultipl
eResponse.txt
I've tried it but didn't work. However, I think is what you are asking for.
Thanks.
Joan Casellas Vega
Media Research Analyst
Phone: +44 7920 761 870
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Nancy Rusinak
Sent: 20 July 2011 03:27
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Count of unique values across variables
Hello!
I'm trying to find a way to get a count of unique values across 6 variables:
zip 2006 zip2007 zip2008 zip2009 zip2010 zip2011
61477
61477 41365
41365 41365 41365 41365 41365 41365
In the data above, I'd like to add a variable called "count." for the first
case, the value of count would be "1" as there is only 1 unique zip in all 6
columns. For the second case, "count" would equal "2" and for the third
case, count would equal "1"
I'm new to syntax and would appreciate any handholding you could offer with
accomplishing this.
My heartfelt thanks if you can help!
Nancy
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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
LISTSERV@LISTSERV.UGA.EDU (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
