VarsToCases and CasesToVars

* RESTRUCTURE WIZARD (Version 12+).

*************.
EXAMPLE #1:
*************.

Q:  I have a database where there are separate lines/cases, each for  a different observation time.  
How do I convert this to a useable file?  Is it possible to do the old SPSS format statement 
and read the separate lines in, naming each variable something that represents the observation time 
(like ID1, ID2, etc.)?

A:  The Restructure Wizard helps you to "restructure" your data from multiple variables (columns) in a 
single case to groups of related cases(rows). Below is a program (Under Data...Restructure)
to accomplish the task without lots of complicated programming.

DATA LIST /ID 2 TIME 5-11 (A) SCORE 13-14.
begin data.
 1  before  73
 1  during  77
 1  after   84
 2  before  58
 2  after   95
 3  before  68
 3  during  70
 3  after   75
end data.

LIST.

SORT CASES BY ID TIME .
CASESTOVARS
 /ID = ID
 /INDEX = TIME
 /GROUPBY = VARIABLE .

*Change the order of the file.

MATCH FILES FILE=*
	/KEEP=id before during after.
EXECUTE.


*************.
*EXAMPLE #2:
*************.

Q:  I have a database where information for one person or organization is stored in one record. 
I want to create separate lines for analysis purposes.  I have hired a programmer to do this, but it's
taking a long time.  Can SPSS do that?

A:  The Restructure Wizard helps you to "restructure" your data from from single-line records
to multiple line records. This file can then be used to Aggregate statistics.

DATA LIST /ID 2 GROUP 4 Grade1 6-7 Grade2 9-10 Grade3 12-13 Grade4 15-17.

BEGIN DATA.
 1 1 11 13 15 18
 2 1 12 18 16 25
 3 2 11 13 13 14
 4 2 18 20  . 29 
 5 3 13 13 13 18
 6 3  9 15 21 35
END DATA.

LIST.


VARSTOCASES /ID = id1
 /MAKE SCORES FROM Grade1 Grade2 Grade3 Grade4
 /INDEX = Index(4)
 /KEEP =  GROUP
 /NULL = KEEP
 /COUNT = NUMRECORDS.