The problem is that your OMS request does not select a particular table type, so OMS tries to put all the tables that Descriptives produces into a single sav file, and, of course, they don't fit dimensionally. (Notes is a table.)
All you have to do is to add an /IF subcommand specifying which type of table you want OMS to capture. The subtype for the descriptives table is 'Descriptive Statistics', so your syntax might look like this.
oms
/IF SUBTYPE= 'Descriptive Statistics'
/destination format=sav
outfile='c:\users\bruce\documents\tempdata.sav'.
You can find the subtype for any table by right clicking in the Viewer outline on an instance of the table or from Utilities>OMS Identifiers,
or you can build the OMS syntax entirely using Utilities>OMS Control Panel.
You can avoid writing a physical file at all by using dataset names assuming that you have at least SPSS 14. You would write
DATASET DECLARE mydesc.
and then use mydesc as the outfile value (no quotes).
HTH,
Jon Peck
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
SPSSX-L@...] On Behalf Of Bruce Colton
Sent: Wednesday, September 17, 2008 3:59 PM
To:
SPSSX-L@...
Subject: [SPSSX-L] oms problem
I am trying to bring the output from the following descriptives procedure into tempdata.sav, where it will be matched against a file created earlier. The output displayed below (21 rows, and 9 cols (" ", n, range, min, max, sum, mean, std_dev, variance) is precisely what I would like to save in tempdata.sav. The warning issued below is not helpful enough for me to crack it. Phase1_stats.sav has 20 cols (var1 - var20), and clearly doesn't equal the number of cols below (9), but why would it, or should it? I would appreciate any help on this; thanks in advance.
get file='c:\users\bruce\documents\phase1_stats.sav'.
oms
/destination format=sav
outfile='c:\users\bruce\documents\tempdata.sav'.
DESCRIPTIVES VARIABLES=var1 to var20
/STATISTICS=MEAN SUM STDDEV VARIANCE RANGE MIN MAX.
Descriptives
c:\users\bruce\documents\phase1_stats.sav
Descriptive Statistics
NRangeMinimumMaximumSumMeanStd. DeviationVariance
var162405.00.005.0017546.002.81191.864683.477
var262405.00.005.0017303.002.77291.819173.309
var362405.00.005.0017740.002.84291.816393.299
var462405.00.005.0017128.002.74491.851773.429
var562405.00.005.0017452.002.79681.850843.426
var662405.00.005.0017104.002.74101.850283.424
var762405.00.005.0017367.002.78321.810273.277
var862405.00.005.0017849.002.86041.810703.279
var962405.00.005.0017969.002.87961.886533.559
var1062405.00.005.0017966.002.87921.886203.558
var1162405.00.005.0017435.002.79411.779223.166
var1262405.00.005.0017327.002.77681.931013.729
var1362405.00.005.0017304.002.77311.894593.589
var1462405.00.005.0017371.002.78381.840723.388
var1562405.00.005.0016828.002.69681.848073.415
var1662405.00.005.0017001.002.72451.845603.406
var1762405.00.005.0017404.002.78911.814113.291
var1862405.00.005.0017474.002.80031.831383.354
var1962405.00.005.0017473.002.80021.816553.300
var2062405.00.005.0017876.002.86471.776043.154
Valid N (listwise)6240
omsend.
OMSEnd
Warnings
Stub sizes of all the tables must matchup. OutFile "c:\users\bruce\documents\tempdata.sav".
This command is not executed.
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (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
LISTSERV@... (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