spss

Load data from an SPSS file.

Introduction

Use the spss instruction to load data from an SPSS file.

Creating a custom script transformation using the spss instruction

To create and configure a custom script using the spss instruction, follow these steps:

1. Create a custom script transformation.

2. In the Instructions step, select the spss instruction.

3. To configure the custom script instruction, fill in the following fields. Required fields are marked with an asterisk (*).

Encoding*

Select the encoding type to use to parse the SPSS file.

Map Labels

Select this field to convert numerical values to their mapped representation.

Header Format

Enter a template to use as a format for the header of the data extract. For example, enter {variable}|{label}.

Subtable

Enter the name for a subtable that you want to use within this custom script.

A subtable is a temporary table that only exists for this custom script. You can apply additional instructions within the same custom script to the subtable. However, the subtable cannot be used in any other custom scripts.

If a subtable does not exist for the current custom script, the transformation is applied to the data extract, and the enriched data is output into the subtable. If the subtable already exists for the custom script, the subtable is used as the input for the transformation and optionally as the output.