converting flat dataset to rectangular dataset

[Caleb Ouma]

Hallo all,
I have data in  SPSS format but it is in flat mode. How do I transform it to rectangular format.
Thanks

Caleb Ouma Ongong'a
Mobile:[phone] and [phone]
Office [phone]
P.O Box 1984-00200
Nairobi-Kenya.

Alternative e-mails
[hidden email]
[hidden email]

"Remember that happiness doesn't depend on what you are or on what you possess, but only on how you think.">




====================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

[Albert-Jan Roskam]

Hi,

Have a look at the VARSTOCASES command in the syntax guide. I don't think you can access it through the GUI.

Cheers!!
Albert-Jan


--- On Thu, 11/13/08, Caleb Ouma <[hidden email]> wrote:

> From: Caleb Ouma <[hidden email]>
> Subject: converting flat dataset to rectangular dataset
> To: [hidden email]
> Date: Thursday, November 13, 2008, 9:40 AM
> Hallo all,
> I have data in  SPSS format but it is in flat mode. How do
> I transform it to rectangular format.
> Thanks
>
> Caleb Ouma Ongong'a
> Mobile:[phone] and [phone]
> Office [phone]
> P.O Box 1984-00200
> Nairobi-Kenya.
>
> Alternative e-mails
> [hidden email]
> [hidden email]
>
> "Remember that happiness doesn't depend on what
> you are or on what you possess, but only on how you
> think.">
>
>
>
>
> ====================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

[Art Kendall]

Please tell us what you mean by "flat mode".  Can you provide a small
example?

Art Kendall
Social Research Consultants


Caleb Ouma wrote:

> Hallo all,
> I have data in  SPSS format but it is in flat mode. How do I transform it to rectangular format.
> Thanks
>
> Caleb Ouma Ongong'a
> Mobile:[phone] and [phone]
> Office [phone]
> P.O Box 1984-00200
> Nairobi-Kenya.
>
> Alternative e-mails
> [hidden email]
> [hidden email]
>
> "Remember that happiness doesn't depend on what you are or on what you possess, but only on how you think.">
>
>
>
>
> ===================
> 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

[ViAnn Beadle]

The UI is Data>Restructure

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Albert-jan Roskam
Sent: Thursday, November 13, 2008 5:43 AM
To: [hidden email]
Subject: Re: converting flat dataset to rectangular dataset

Hi,

Have a look at the VARSTOCASES command in the syntax guide. I don't think
you can access it through the GUI.

Cheers!!
Albert-Jan


--- On Thu, 11/13/08, Caleb Ouma <[hidden email]> wrote:

> From: Caleb Ouma <[hidden email]>
> Subject: converting flat dataset to rectangular dataset
> To: [hidden email]
> Date: Thursday, November 13, 2008, 9:40 AM
> Hallo all,
> I have data in  SPSS format but it is in flat mode. How do
> I transform it to rectangular format.
> Thanks
>
> Caleb Ouma Ongong'a
> Mobile:[phone] and [phone]
> Office [phone]
> P.O Box 1984-00200
> Nairobi-Kenya.
>
> Alternative e-mails
> [hidden email]
> [hidden email]
>
> "Remember that happiness doesn't depend on what
> you are or on what you possess, but only on how you
> think.">
>
>
>
>
> ====================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

=====================
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

[Richard Ristow]

At 03:40 AM 11/13/2008, Caleb Ouma wrote:

>I have data in  SPSS format but it is in flat mode. How do I
>transform it to rectangular format.

Yes, as Art Kendall wrote, please make clearer what you mean. ('Flat'
and 'rectangular' seem to mean the same thing.)

At 07:43 AM 11/13/2008, Albert-jan Roskam wrote:

>Have a look at the VARSTOCASES command in the syntax guide. I don't
>think you can access it through the GUI.

It's likely that VARSTOCASES or its counterpart, CASESTOVARS, will do
what you want. Both can be accessed from the menus, choose
Data > Restructure...
then select "Restructure selected variables into cases" or
"Restructure selected cases into variables".

Both commands are complex. Often, it's useful to paste the syntax
from that the menus generate, and then modify it.

Also, finally, think carefully what you want to do. You may find it
useful to read the recent thread "Reading in Hierarchical Data",
begun Wed, 29 Oct 2008.

-Best of luck,
  Richard

=====================
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