OTHER Keyword (RECORD TYPE command)

OTHER specifies all record types that have not been mentioned on previous RECORD TYPE commands.

  • OTHER can be specified only on the last RECORD TYPE command in the file definition.
  • OTHER can be used with SKIP to skip all undefined record types.
  • For nested files, OTHER can be used only with SKIP. Neither can be used separately.
  • If WILD=WARN is in effect for the FILE TYPE command, OTHER cannot be specified on the RECORD TYPE command.

Using Keyword OTHER With a Mixed File

FILE TYPE  MIXED FILE=TREATMNT RECORD=RECID 1-2.
RECORD TYPE 21,22,23,24.
DATA LIST   /SEX 5 AGE 6-7 DOSAGE 8-10 RESULT 12.
RECORD TYPE 25.
DATA LIST   /SEX 5 AGE 6-7 DOSAGE 10-12 RESULT 15.
RECORD TYPE OTHER.
DATA LIST   /SEX 5 AGE 6-7 DOSAGE 18-20 RESULT 25.
END FILE TYPE.
  • The first two RECORD TYPE commands specify record types 21–25. All other record types are specified by the third RECORD TYPE.

Using Keyword OTHER With a Nested File

FILE TYPE NESTED FILE=ACCIDENT RECORD=#RECID 6 CASE=ACCID 1-4.
RECORD TYPE 1.        /* Accident record
DATA LIST   /WEATHER 12-13.
RECORD TYPE 2.        /* Vehicle record
DATA LIST /STYLE 16.
RECORD TYPE OTHER SKIP.
END FILE TYPE.
  • The third RECORD TYPE specifies OTHER SKIP. Type 2 records are therefore the lowest-level records included in the active dataset. These commands build one case for each vehicle record. The person records are skipped.
  • Because the data are in a nested file, OTHER can be specified only with SKIP.