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: Seeing if the last observation equals previous observations from a variable X

 From Tim Wade 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–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index