Date: Wed, 10 Apr 2002 08:32:38 -0500
Reply-To: "Marks, Jim" <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Marks, Jim" <email@example.com>
Subject: Re: Switching variables and observations
the command you want is FLIP.
It is available through syntax, or through the GUI at Data/ Transpose.
FLIP switches rows and columns. String values do not flip, and value labels
and variable labels do not transfer. Flip creates a variable called CASE_LBL
which holds the names from the old file.
You can provide a variable list or flip all variables.
FLIP will create new variables named VAR001 to VARn or it will use CASE_LBL
if present. You can override this naming convention with /NEWNAMES = varname
to create new names. If the naming variable is numeric, you get v_#. If the
naming variable is a string, you get @@@@@@@@ (Uppercase; long strings get
truncated). Duplicate names get numbered.
From a file with minute by minute observations for a number of days:
FLIP VARIABLES = min_1 to min_1440 /NEWNAMES = day.
LodgeNet Entertainment Corporation
IMPORTANT NOTICE: This communication (including any attached files) is
intended for the entity to which it is directed and may contain confidential
and proprietary information of LodgeNet Entertainment Corporation. The
communication is provided under the terms of the nondisclosure agreement
between LodgeNet and the intended recipient. If you are not acting solely
on behalf of the intended recipient with respect to the receipt of this
communication, you are not authorized to receive, retain, print or forward
this communication. In that event, you are directed to destroy this
communication (including any attached files), and to advise
firstname.lastname@example.org that you received this communication in error. If
you are authorized to receive this communication on behalf of the intended
recipient, you are obligated to treat it as confidential and proprietary
information of LodgeNet Entertainment Corporation, in accordance with the
nondisclosure agreement mentioned above.
From: Robert Andrew Bowell Jr. [mailto:email@example.com]
Sent: Wednesday, April 10, 2002 7:51 AM
Subject: Switching variables and observations
I'm helping someone who has a data set that basically needs to be
swapped. What are now observations have to become variables and what are
now variables have to become observations. How can I do this?
User Services Support Specialist
Busch Campus, Hill Center, Room 279
Phone: 732-445-2464/Fax: 732-445-5539