Hello @qwerty12,
The key for the "other" category to work is that variable HLO='O'. If HLO is blank or not even contained in your CNTLIN dataset, the string "**OTHER**" in the START and END variables is treated like any other string. It has no special meaning. However, if HLO='O', the values of START and END are ignored for that observation, so you can leave them blank. The string "**OTHER**" for START and END will appear in FMTLIB output and a CNTLOUT dataset automatically. There is no need to type it.
Example:
data fmt;
retain fmtname '$testfmt';
input start $ label $ hlo $;
cards;
A one .
B two .
. any O
;
proc format cntlin=fmt;
run;
data _null_;
do c='A','B','X';
put c $testfmt.;
end;
run;
... View more
