Date:         Tue, 26 Sep 2006 13:27:48 -0400
Reply-To:     Richard Ristow <wrristow@mindspring.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Richard Ristow <wrristow@mindspring.com>
Subject:      Re: restructuring data
Comments: To: "Raffe, Sydelle, SSA" <DRaffe@ACGOV.ORG>
In-Reply-To:  <D584AFE160F371489F66B181D6F7387902850401@US001EX04V.user.r
              oot.acgov.org>
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 08:09 PM 9/25/2006, Raffe, Sydelle, SSA wrote:

>I'm trying to restructure a data set with only 1 variable, a case id.
>Instead of 3780 records with different values of caseid, I want 1
>record with the values of caseid going across. There would be 1 record
>with 3780 case id fields.

I think CASESTOVARS is in 11.5. This is the simplest possible use of
it. This is SPSS draft output.

LIST.

List
|-----------------------------|---------------------------|
|Output Created               |26-SEP-2006 13:22:56       |
|-----------------------------|---------------------------|
CaseID

Alpha
Beta
Gamma
Delta
Epsilon
Eta
Theta

Number of cases read:  7    Number of cases listed:  7


CASESTOVARS.


Cases to Variables

Notes
|--------------------------|---------------------------|
|Output Created            |26-SEP-2006 13:23:22       |
|--------------------------|---------------------------|

Generated Variables
|---------|--------|
|Original |Result  |
|Variabl  |--------|
|e        |Name    |
|-------|-|--------|
|CaseID |1|CaseID.1|
|       |-|--------|
|       |2|CaseID.2|
|       |-|--------|
|       |3|CaseID.3|
|       |-|--------|
|       |4|CaseID.4|
|       |-|--------|
|       |5|CaseID.5|
|       |-|--------|
|       |6|CaseID.6|
|       |-|--------|
|       |7|CaseID.7|
|-------|-|--------|

Processing Statistics
|---------------|---|
|Cases In       |7  |
|---------------|---|
|Cases Out      |1  |
|---------------|---|
|Cases In/Cases |7.0|
|Out            |   |
|---------------|---|
|Variables In   |1  |
|---------------|---|
|Variables Out  |7  |
|---------------|---|
|Index Values   |7  |
|---------------|---|


LIST.

List
|-----------------------------|---------------------------|
|Output Created               |26-SEP-2006 13:23:47       |
|-----------------------------|---------------------------|
The variables are listed in the following order:

LINE   1: CaseID.1 CaseID.2 CaseID.3 CaseID.4
LINE   2: CaseID.5 CaseID.6 CaseID.7

     CaseID.1: Alpha           Beta            Gamma           Delta
     CaseID.5: Epsilon         Eta             Theta

Number of cases read:  1    Number of cases listed:  1