rowfirst(varlist)
may not be combined with by. It gives the first nonmissing value in varlist for each
observation (row). If all values in varlist are missing for an observation, newvar
is set to missing.
rowlast(varlist)
may not be combined with by. It gives the last nonmissing value in varlist for each
observation (row). If all values in varlist are missing for an observation, newvar
is set to missing.
rowmax(varlist)
may not be combined with by. It gives the maximum value (ignoring missing values) in
varlist for each observation (row). If all values in varlist are missing for an
observation, newvar is set to missing.
rowmean(varlist)
may not be combined with by. It creates the (row) means of the variables in varlist,
ignoring missing values; for example, if three variables are specified and, in some
observations, one of the variables is missing, in those observations newvar will
contain the mean of the two variables that do exist. Other observations will contain
the mean of all three variables. Where none of the variables exist, newvar is set to
missing.
rowmedian(varlist)
may not be combined with by. It gives the (row) median of the variables in varlist,
ignoring missing values. If all variables in varlist are missing for an observation,
newvar is set to missing in that observation. Also see rowpctile().
rowmin(varlist)
may not be combined with by. It gives the minimum value in varlist for each
observation (row). If all values in varlist are missing for an observation, newvar
is set to missing.
rowmiss(varlist)
may not be combined with by. It gives the number of missing values in varlist for
each observation (row).
rownonmiss(varlist) [, strok]
may not be combined with by. It gives the number of nonmissing values in varlist for
each observation (row) -- this is the value used by rowmean() for the denominator in
the mean calculation.
String variables may not be specified unless the strok option is also specified. If
strok is specified, string variables will be counted as containing missing values
when they contain "". Numeric variables will be counted as containing missing when
their value is ">.".
rowpctile(varlist) [, p(#)]
may not be combined with by. It gives the #th percentile of the variables in
varlist, ignoring missing values. If all variables in varlist are missing for an
observation, newvar is set to missing in that observation. If p() is not specified,
p(50) is assumed, meaning medians. Also see rowmedian().
rowsd(varlist)
may not be combined with by. It creates the (row) standard deviations of the
variables in varlist, ignoring missing values.
rowtotal(varlist) [, missing]
may not be combined with by. It creates the (row) sum of the variables in varlist,
treating missing as 0. If missing is specified and all values in varlist are missing
for an observation, newvar is set to missing.