Date:         Fri, 13 Feb 2009 09:36:04 -0600
Reply-To:     "Oliver, Richard" <roliver@spss.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Oliver, Richard" <roliver@spss.com>
Subject:      Re: importing/transposing data structure
Comments: To: Ronald Fischer <Ronald.Fischer@vuw.ac.nz>
In-Reply-To:  A<887C86D1DF90704EAF7DD863E6E60322300D0DA7C5@STAWINCOEXMAIL1.staff.vuw.ac.nz>
Content-Type: text/plain; charset="US-ASCII"

Look at CASESTOVARS (or the Restructure Data Wizard).

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Ronald Fischer
Sent: Friday, February 13, 2009 9:06 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: importing/transposing data structure

HI,
I have a dat file in which i have a 100 groups of 44 continuously numbered variable id number identifying two variables (which are dimensions).

this is what it looks like (3 columns x 4400 rows):

1  0.12  -0.16
2 1.23  1.25
3 -0.10 0.00
...
44 0.12 -0.16
1  0.14  0.14
2  0.16  0.17
...
44  0.17  1.24
and so.

how could i import and/or transpose this structure so that i have only 44 rows and 300 columns?

any advice would be much appreciated. thanks a lot in advance

Ron Fischer
Victoria University of Wellington

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD