listwise (dataloop)

Purpose

Controls listwise deletion of missing values.

Format

listwise [[read]] [[write]];

Remarks

If read is specified, the deletion of all rows containing missing values happens immediately after reading the input file and before any transformations. If write is specified, the deletion of missing values happens after any transformations and just before writing to the output file. If no Format statement is present, rows with missing values are not deleted.

The default is read.

Examples

// Delete rows with missing values before transformations
listwise read;

// Delete rows with missing values after transformations
listwise write;