I believe you are correct. There is no obvious row mode function and
-collapse- does not support modes.
However, in your specific problem, there is an easy trick. The mode of 3
might as well be the median of 3. If any value occurs twice or three
times in 3 values, it will also be the median. If each distinct value
occurs just once, the mode might as well be the median too, unless for
some reason you want to insist that a mode is a value that is repeated.
Thus,
. search row median
for a nauseatingly long-winded FAQ on that problem with a pointer to an
efficient user-written -egen- function.
For rows with more than 3 values, do something like this. Example for
variables p1-p4. This is crude code, and will be slow, but I think it
generalises without pain.
gen foo = .
gen mode = .
qui forval i = 1/`=_N' {
forval j = 1/4 {
replace foo = p`j'[`i'] in `j'
}
egen bar = mode(foo) in 1/4
replace mode = bar[1] in `i'
drop bar
}
Nick
[email protected]
Fernando H. Andrade
I am trying to compute the equivalent to a rowmode, a function similar
to
rowmean in the egen command. i think the ado for a rowmode function
(which
may compute the mode across several variables) does not exist, does it?
as
an alternative i thought to reshape the data and collapse it using the
mode
but the mode is not a function to collapse the data.
is there a way to compute the mode across a set of variables for each
subject?
to be more concrete:
this is the structure of the data
subject p1 p2 p3
1 2 2 4
2 1 1 3
3 2 2 4
4 1 1 1
5 3 4 4
i would like to generate a new variable containing the mode across p1 to
p3
for each one of the subjects such that for subject 1 the generated value
would be 2, and 1, 2, 1,4 for subjects 2,3,4,5 respectively.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
