Course Overview

This syntax course focuses on powerful data transformations (only available in syntax – not in the GUI) and on automation. For automation, the two main topical areas are Macros and the Production Facility. The Macro language is discussed in detail, with examples showing how Macros can make your syntax more efficient, more transparent and easier. The discussion of the Production Facility shows how syntax files can be scheduled in the Windows environment (the same applies to other operating systems).

Who Should Attend

This intermediate course is a natural follow-on to the introductory SPSS Statistics Syntax I course and is designed for experienced users wishing to become proficient syntax programmers.


You should have:
  • a knowledge of syntax on the level of SPSS Statistics Syntax I
  • an experience in using syntax and a feeling for programming.

Course Content

Syntax for file operations
  • Merging files
  • Aggregating files
  • Restructuring files
Syntax using functions in transformations
  • String functions
  • Date and Time functions
  • Statistical functions
  • Missing value functions
Powerful transformations
  • Repeating transformations across numerous variables
  • The LOOP command
  • The VECTOR command
  • Combining the LOOP and VECTOR commands
  • The idea of a macro
  • Debugging a macro
  • Using arguments
  • Loop structures
  • Conditional processing of commands
  • Working with string macro-variables
  • General recommendations on handling macros
The Production facility
  • Introduction to production jobs
  • How to run a production job
  • How to schedule a production job
The Output Management System (OMS) facility
  • Introduction to OMS
  • Using OMS to save output as a data file
  • Practical examples of OMS