Date: Thu, 1 Sep 2005 14:44:53 -0400
Reply-To: thennig@idirect.com
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Timothy Hennigar <thennig@idirect.com>
Organization: Timothy Hennigar
Subject: Re: Position in the ramking to new variables
In-Reply-To: <8D626A9DC3B7E14893DD6E3C9E3E3EE0010012@servidor.acziona.local>
Content-Type: text/plain; charset="iso-8859-1"
I just pasted your numbers in to a blank data editor
Transposed your data using
FLIP
VARIABLES=VAR00001 VAR00002 VAR00003 VAR00004 .
Created 2 new ranking variables
RANK
VARIABLES=var001 var002 (A) /RANK /PRINT=YES
/TIES=MEAN .
Variables Created By RANK
Then flipped the data back
FLIP
VARIABLES=CASE_LBL var001 var002 Rvar001 Rvar002 .
Worked for me:
var001 5.00 3.00 72.00 8.00
var002 1.00 7.00 4.00 16.00
Rvar001 2.00 1.00 4.00 3.00
Rvar002 1.00 3.00 2.00 4.00
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Victor Tarrago
Sent: Thursday, September 01, 2005 1:02 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Position in the ramking to new variables
Dear list,
We have a "big" problem and we would like to solve it with SPSS. We have 4
different variables (4 channels - x1, x2, x3 and x4) with utility values and
we would like to create 4 new variables (one for each channel - y1, y2, y3
and y4) which value has to be the order of each channel in the ranking based
on the utilities for each case.
Considering only two cases, we have something like this:
X1 X2 X3 X4
Case 1 5 3 72 8
Case 2 1 7 4 16
And we would like to obtain something like this:
y1 y2 y3 Y4
Case 1 2 1 4 3
Case 2 1 3 2 4
How can we get it? Thank you for your response.
Victor Tarragó Sanromà
Acziona Quanlitative Market Consultants
Tel. + 34 93.238.43.53
Fax. + 34 93.238.45.99
vtarrago@acziona.com
www.acziona.com
-------------------------------------------------------------------
Important Notice
This communication contains information which is confidential and/or
privileged and may not necessarily represent the opinion of ACZIONA. It is
for the exclusive use of the intended recipient(s). If you are not the
intended recipient(s) please remind that any distribution, copying or use of
this communication or the information in it, is strictly prohibited. If you
have received this communication in error please notify us immediately by
email and then delete this message and any copies of it.
Aviso Importante
Este comunicado contiene información confidencial y/o privilegiada y no
necesariamente refleja la opinión de ACZIONA. Es para uso exclusivo de su
destinatario. Si usted no es su destinatario, tenga en consideración que
cualquier acción de distribución, copia o uso total o parcial de esta
comunicación o de la información que contiene está estrictamente prohibida.
Si usted recibe el mensaje por error, por favor comuníqueselo inmediatamente
al remitente a través del e-mail y elimine este mensaje o a cualquier copia
de este.
