Date:         Sun, 6 Mar 2011 11:30:08 -0800
Reply-To:     David Marso <david.marso@gmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         David Marso <david.marso@gmail.com>
Subject:      Re: different values in a row
In-Reply-To:  <1299437410328-3411660.post@n5.nabble.com>
Content-Type: text/plain; charset=us-ascii

See my previously posted solution.  The First piece is essentially a FLIP BY
ID.
AGGREGATE takes care of the rest.
---------

martus wrote:
>
> I only have a crude concept, not fully worked out:
> For one case you may use the flip command to get the values
> in one column, named variable. Than you sort and  write the command
> if (lag(variable) = variable) indicator = 1.
> you delete all cases with indicator = 1, the number of cases equals
> the number of different values.
> This solution works for arbitrary numbers per row, but only for
> one case in the original file. Maybe its possible to extend it to
> arbitrary number of
> cases in the original file by including a loop on the variables in
> the flipped file.
> Peter
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/different-values-in-a-row-tp3411280p3411684.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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