Capture SPSS Regression Coefficients into a Dataset Using the Output Management System

Quick answer: route SPSS output straight into a data file

If you need the numbers from a procedure (for example, the regression coefficients table) as a dataset you can merge, sort, or export, use the Output Management System (OMS). OMS watches the SPSS output stream, selects tables that match your criteria, and writes them to an external .sav file without manual copy‑paste.

Worked configuration: capture the Coefficients table from REGRESSION

1. Run the analysis whose table you want.
2. Surround it with an OMS block that selects the table subtype and names the destination file.
3. After the block, read the saved file back with GET FILE.

* Example: save regression coefficients.
REGRESSION
  /DEPENDENT score
  /METHOD=enter age income.
OMS
  /SELECT TABLES
  /IF SUBTYPES='Coefficients'
  /DESTINATION OUTFILE='C:\\temp\\coefs.sav'.
GET FILE='C:\\temp\\coefs.sav'.
EXECUTE.

The OMS command tells SPSS: “whenever a table appears, if its subtype is exactly ‘Coefficients’, write that table to the file coefs.sav.” When the REGRESSION finishes, the Coefficients table is captured and the GET FILE command opens it as a regular SPSS dataset.

How OMS works under the hood

OMS acts as a filter on the output stream. Each piece of output (tables, text, charts) has a procedure name and a subtype visible in the Viewer outline. The /SELECT TABLES clause limits OMS to tables; the /IF SUBTYPES='…' clause further narrows it to a specific subtype. Matching tables are written to the destination file, preserving variable names, labels, and measurement levels.

Limits and common mistakes

• Only items that match the SELECT criteria are written. Charts, log items, or text output need separate OMS calls or manual export.
• Subtype names are case‑sensitive and can change between SPSS versions; always verify the exact string for your release (Utilities → Output Management System shows the generated syntax).
• OMS captures the final output of a procedure; intermediate calculations or temporary tables are not saved.
• If the destination file already exists, OMS silently overwrites it. Use a unique filename or check the file handle after long jobs.

Practical verification

1. Open Utilities > Output Management System, pick a procedure (e.g., REGRESSION), and note the syntax SPSS generates—this confirms the supported subtypes in your version.
2. Run the example above on a small dataset, then inspect the imported file with VARIABLE LABELS or DISPLAY DICTIONARY to ensure the Coefficients table arrived intact.
3. Before scaling to a batch job, test with a single case and verify that GET FILE can read the file without errors.