Date:         Thu, 20 May 2004 11:43:26 +0200
Reply-To:     Mark Webb <targetlk@iafrica.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Mark Webb <targetlk@iafrica.com>
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
product.
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
EB                                 BB

This reads - browsed A first, B second. Evaluated A first, B second. Bought
B first.

Any suggestions welcome.
 I've been trying to do this using the VECTOR/LOOP/DO IF/COMPUTE commands &
getting close but not exacly there.

Mark Webb
TargetLink Research
P O Box 13040 Mowbray 7705
1st Floor, Standard Bank Building
37 Main Rd, Mowbray, Cape Town
Phone   021-689-8848
Fax       021-686-9493
Cell       072 199 1000
e-mail    targetlk@iafrica.com