importing/transposing data structure

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

importing/transposing data structure

Ronald Fischer-7
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
[hidden email] (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
Reply | Threaded
Open this post in threaded view
|

Re: importing/transposing data structure

Oliver, Richard
Look at CASESTOVARS (or the Restructure Data Wizard).

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ronald Fischer
Sent: Friday, February 13, 2009 9:06 AM
To: [hidden email]
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
[hidden email] (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
[hidden email] (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