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 <[email protected]>
To
[email protected]
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
<[email protected]> 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/