LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2005)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments: To: Victor Tarrago <vtarrago@acziona.com>
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.


Back to: Top of message | Previous page | Main SPSSX-L page