vars to cases with 11.5.1

[Raffe, Sydelle, SSA]

I have a data set which has 3 sets of 4 variables each. I'm using data>restructure>vars to cases. I'm trying to move the last 2 groups into the first 4 columns of the data file as follows:

        aaaabbbbcccc to

        aaaa
        bbbb
        cccc

Here is a file with 2 rows of actual data.

         
After I define the second group to be transposed, a dialogue box opens saying that each variable in each group must be of the same type. They are all strings. The procedure stops there. Can anyone get me to where I want to go? Thanks.

Sydelle Raffe, Alameda County Social Services Agency
Information Services Division
e:mail:  [hidden email]
phone: [phone]     fax: [phone]
If you have a request for information, please submit an ODM request form at:  https://alamedasocialservices.org/staff/support_services/statistics_and_reports/odm/index.cfm

[Richard Ristow]

At 06:48 PM 10/6/2006, Raffe, Sydelle, SSA wrote:

>I have a data set which has 3 sets of 4 variables each. I'm using
>data>restructure>vars to cases. I'm trying to move the last 2 groups
>into the first 4 columns of the data file as follows:
>
>         aaaabbbbcccc to
>
>         aaaa
>         bbbb
>         cccc
>
>Here is a file with 2 rows of actual data.

<That didn't make it into your posting>

>After I define the second group to be transposed, a dialogue box opens
>saying that each variable in each group must be of the same type. They
>are all strings. The procedure stops there. Can anyone get me to where
>I want to go? Thanks.

For SPSS, each *length* string is a different type. You want to
restructure

a1 a2 a3 a4 b1 b2 b3 b4 c1 c2 c3 c4

into
a1 a2 a3 a4
b1 b2 b3 b4
c1 c2 c3 c4

That requires that a1, b1 and c1, if strings, have the same length; the
same for a2, b2 and c2, etc.

No guarantees, without seeing your data, but this MAY be the problem.

-Good luck,
  Richard