Date: Thu, 20 May 2004 11:43:26 +0200
Reply-To: Mark Webb <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Mark Webb <firstname.lastname@example.org>
Subject: Data restructuring logic difficulty - any suggestions ?
Content-Type: text/plain; charset="iso-8859-1"
Any help with the following would be greatly appreciated.
I have data where respondents can do 3 actions - Browse, Evaluate or Buy a
The data is captured in action sequence i.e. as they do the actions.
I want to convert this data from action sequence like browse A, evaluate A,
browse B, evaluate B, buy B into
Browse 1, Browse 2, Browse 3, Evalute 1, Evalute 2, Evaluate 3, Buy 1, Buy
2, Buy 3. [assuming max of 3 specific actions].
Data could look like -
Action1 Action2 Action3 Action4 Action5 ActionX
BA EA BB EB BB
This reads as actions ->browse A, evaluate A, browse B, evaluate B, buy B
The output I need would look like -
FirstBrowse SecondBrowse ThirdBrowse FirstEval SecondEval
ThirdEval FirstBuy SecondBuy ThirdBuy
BA BB EA
This reads - browsed A first, B second. Evaluated A first, B second. Bought
Any suggestions welcome.
I've been trying to do this using the VECTOR/LOOP/DO IF/COMPUTE commands &
getting close but not exacly there.
P O Box 13040 Mowbray 7705
1st Floor, Standard Bank Building
37 Main Rd, Mowbray, Cape Town
Cell 072 199 1000