Diff for "FAQ/restwb" - CBU statistics Wiki
location: Diff for "FAQ/restwb"
Differences between revisions 1 and 2
Revision 1 as of 2010-01-26 16:10:49
Size: 618
Editor: PeterWatson
Comment:
Revision 2 as of 2010-01-26 16:17:35
Size: 618
Editor: PeterWatson
Comment:
Deletions are marked like this. Additions are marked like this.
Line 10: Line 10:
001 23 45
001 39 41
002 33 11
002 87 57
002 99 36
002 23 45
003 39 41
004 33 11
005 87 57
006 99 36

The VARSTOCASES command

The below can also be performed using the RESTRUCTURE command under the DATA menu in SPSS. For the example below we wish to stack columns x and y to make a single column called time. This is particularly useful for converting data from a format suitable for repeated measures to one suitable for multilevel modelling in SPSS.

DATA LIST FREE / idno x y . 
BEGIN DATA 
001 34 56 
002 23 45 
003 39 41 
004 33 11 
005 87 57 
006 99 36 
END DATA. 

SORT CASES BY IDNO.
VARSTOCASES 
 /MAKE time FROM x y
 /INDEX = newfact "new var label" (time) 
 /KEEP = idno.

None: FAQ/restwb (last edited 2015-08-11 08:38:08 by PeterWatson)