Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Seeing if the last observation equals previous observations from a variable X


From   Tim Wade <wadetj@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Seeing if the last observation equals previous observations from a variable X
Date   Sat, 24 Apr 2010 17:25:05 -0400

George maybe something like this:

input str10 a b c
one 1 2
two 2 3
one 3 4
two 1 2
five 0 0
one 1 1
end

qui count
local count=r(N)
gen same=0

forvalues i=1/`count'{
replace same=1 in `i' if a[`i']==a[_N]
}


. list

     +---------------------+
     |    a   b   c   same |
     |---------------------|
  1. |  one   1   2      1 |
  2. |  two   2   3      0 |
  3. |  one   3   4      1 |
  4. |  two   1   2      0 |
  5. | five   0   0      0 |
     |---------------------|
  6. |  one   1   1      1 |
     +---------------------+

Hope this helps, Tim


On Sat, Apr 24, 2010 at 5:06 PM, George Chioran
<george_chioran@yahoo.com> wrote:
> Dear Statalisters,
>
> I want to know how I
> could see if the last observation in a variable X (containing strings) is equal
> to other observations in the variable. I know I can use X[_N] to identify the
> last observation in the variable, but how could I see if I have a previously
> identical observation to X[_N] in the variable?
>
> Thank you a lot for
> the help,
> George
>
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index