Example 2
SELECT FROM(INPUT) TO(ONLYONE) ON(23,3,FS) NODUPS
Sorts the INPUT data set to the ONLYONE data set, selecting only the records from INPUT with floating sign values in positions 23-25 that occur just once (that is, only records with no duplicate ON field values).
The ONLYONE data set might look as follows (several records are shown for illustrative purposes):
DFSRT2 BOENIG 5 DOC.EXAMPLES
DFSRT1 PACKER 8 ICETOOL.SMF.RUNS
USR002 BETTEN 12 DOC.EXAMPLES
SYS003 YAEGER 32 ICETOOL.TEST.CASES
DFSRT2 CORNELL 108 FS.TEST.CASES
. . . .
. . . .
. . . .