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 (May 2011)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Sun, 15 May 2011 17:37:20 -0500
Reply-To:   Rick Oliver <>
Sender:   "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:   Rick Oliver <>
Subject:   Re: Use pivot tables from output as new input
Comments:   To: John Test <tt@STARMEDIX.DE>
In-Reply-To:   <>
Content-Type:   multipart/alternative;

OMS requests remain in effect until an OMSEND command is issued. If you are using the OMS Control Panel, the End button ends the selected OMS request.

The help contains several examples of the results of OMS commands in a topic called "Routing output to IBM SPSS Statistics data files", but it does not show the related command syntax. Here is the syntax for two of the examples:

oms /select tables /if commands=['Means'] subtypes=['Report'] /destination format=sav outfile='c:\temp\temp.sav' /tag='oms_means'.

MEANS TABLES=salbegin salary jobtime BY gender /CELLS MEAN MEDIAN MIN MAX .

omsend tag=['oms_means'].

oms /select tables /if subtypes=['Frequencies'] /destination format=sav outfile='c:\temp\temp.sav' /tag='oms_freq'.

freq var=gender jobcat.

omsend tag=['oms_freq'].

In these examples, the tag is not actually necessary, since there is no overlap between the two OMS commands. OMS requests can be more sophisticated than this. You can have multiple OMS requests in effect at the same time, and you can rotate the contents of the pivot tables with the COLUMNS subcommand.

From: John Test <tt@STARMEDIX.DE> To: SPSSX-L@LISTSERV.UGA.EDU Date: 05/15/2011 10:00 AM Subject: Re: Use pivot tables from output as new input Sent by: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>

hi short additional question about OMS: I've understand (hopefully) how to create this OMS request to export tables to SPSS data file. However, there is no special example given in the help and my question is: does the OMS only affect further analyses in future, or can I also export existing tables in the output file for further analysis, even when the data file is not available anymore, thus the analyis cannot be rerun? Thanks!

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


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