MISSING Subcommand (AGGREGATE command)
By default, AGGREGATE
uses all nonmissing values of the source variable to calculate aggregated
variables. An aggregated variable will have a missing value only if
the source variable is missing for every case in the break group.
You can alter the default missing-value treatment by using the MISSING
subcommand. You can also specify
the inclusion of user-missing values on any function.
-
MISSING
must immediately followOUTFILE
. -
COLUMNWISE
is the only specification available forMISSING
. - If
COLUMNWISE
is specified, the value of an aggregated variable is missing for a break group if the source variable is missing for any case in the group. -
COLUMNWISE
does not affect the calculation of theN
,NU
,NMISS
, orNUMISS
functions. -
COLUMNWISE
does not apply to break variables. If a break variable has a missing value, cases in that group are processed and the break variable is saved in the file with the missing value. UseSELECT IF
if you want to eliminate cases with missing values for the break variables.