LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 10 Apr 2002 08:32:38 -0500
Reply-To:     "Marks, Jim" <>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Marks, Jim" <>
Subject:      Re: Switching variables and observations
Content-Type: text/plain

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.

Cheers Jim Marks Market Analyst LodgeNet Entertainment Corporation 605.988.1616

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

-----Original Message----- From: Robert Andrew Bowell Jr. [] Sent: Wednesday, April 10, 2002 7:51 AM To: SPSSX-L@LISTSERV.UGA.EDU 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?


Rob Bowell User Services Support Specialist Busch Campus, Hill Center, Room 279 Phone: 732-445-2464/Fax: 732-445-5539

Back to: Top of message | Previous page | Main SPSSX-L page