Adding a Value Test to RESTRICT=NOPRINT

Under prior releases, a RESTRICT=NOPRINT DBA restriction displayed all values or only default values (blank, zero, or MISSING).

This optional extension to RESTRICT=NOPRINT enables you to use a VALUE=expression clause in the RESTRICT command. The expression will be evaluated, and the value will display only if the expression evaluates to true for that value. Any value for which the expression evaluates to false will be replaced on the output by one of the default values.

Therefore, a DBA command that includes the following restriction will only display the true value of SEATS when COUNTRY has the value 'ENGLAND'. Otherwise, default values are displayed:

RESTRICT=NOPRINT, NAME=SEATS, [VALUE= COUNTRY EQ 'ENGLAND';,]$ 

iWay Software