* Posted to SPSSX-L list on 2001/03/18. * rlevesque@videotron.ca. * What to restructure the data file. Run syntax to and look at data editor to * see the objective. DATA LIST LIST /resp purch eggs_1 meat_1 fish_1 apple_1 fruit_1. BEGIN DATA 1 1 4 2 4 5 74 1 2 3 1 6 5 4 1 3 1 3 8 6 5 1 4 0 1 2 3 4 2 1 2 5 4 5 82 2 2 2 5 1 2 4 3 1 3 2 1 4 5 4 1 5 2 1 4 4 5 1 2 2 2 2 0 5 2 2 1 5 0 0 END DATA. LIST. VECTOR eggs meat fish apple fruit(4F8.0). DO REPEAT a=eggs meat fish apple fruit /b=eggs_1 meat_1 fish_1 apple_1 fruit_1. COMPUTE a(purch)=b. END REPEAT. EXECUTE. AGGREGATE /OUTFILE=* /BREAK=resp /eggs1 TO eggs4 = MAX(eggs1 TO eggs4) /meat1 TO meat4 = MAX(meat1 TO meat4) /fish1 TO fish4 = MAX(fish1 TO fish4) /apple1 TO apple4 = MAX(apple1 TO apple4) /fruit1 TO fruit4 = MAX(fruit1 TO fruit4).