Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: Row mode
From
"Md. Alauddin Majumder" <[email protected]>
To
"[email protected]" <[email protected]>
Subject
RE: st: Row mode
Date
Thu, 16 May 2013 11:30:42 +0000
Thanks Nick and Maarten for your instructive suggestions!
Majumder
________________________________________
From: [email protected] [[email protected]] on behalf of Nick Cox [[email protected]]
Sent: Thursday, May 16, 2013 2:31 AM
To: [email protected]
Subject: Re: st: Row mode
See http://www.stata.com/statalist/archive/2013-04/msg00301.html for a
comment on expressions like "a data".
The easiest way I know is to -reshape- before and after. Note that
-egen, mode()- won't play with your 4th example, where 3 and 4 tie for
mode, so you need a rule such as -minmode-.
. l
+---------------------------+
| row1 row2 row3 row4 |
|---------------------------|
1. | 1 3 1 4 |
2. | 3 3 4 1 |
3. | 1 4 2 2 |
4. | 4 4 3 3 |
+---------------------------+
. gen id = _n
. reshape long row, i(id)
(note: j = 1 2 3 4)
Data wide -> long
-----------------------------------------------------------------------------
Number of obs. 4 -> 16
Number of variables 5 -> 3
j variable (4 values) -> _j
xij variables:
row1 row2 ... row4 -> row
-----------------------------------------------------------------------------
. egen mode = mode(row), by(id) minmode
. reshape wide
(note: j = 1 2 3 4)
Data long -> wide
-----------------------------------------------------------------------------
Number of obs. 16 -> 4
Number of variables 4 -> 6
j variable (4 values) _j -> (dropped)
xij variables:
row -> row1 row2 ... row4
----------------------------------------------------------------------
Nick
[email protected]
On 16 May 2013 07:20, Md. Alauddin Majumder <[email protected]> wrote:
> Dear Statalist,
> I have a data like the following:
>
> Row1 Row2 Row3 Row4
> 1 3 1 4
> 3 3 4 1
> 1 4 2 2
> 4 4 3 3
>
> I want to find ROW MODE. Any help will be greatly appreciated!
>
> Thanks in advance
> Majumder
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/faqs/resources/statalist-faq/
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/