Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# RE: st: add up variable / quantile

 From "Scharnigg, Stan (Stud. SBE)" To "statalist@hsphsun2.harvard.edu" Subject RE: st: add up variable / quantile Date Thu, 14 Apr 2011 17:55:05 +0200

```aha, then is that the problem. Because var1 has 2.3 million observations and var2 has 5000 observation.
However, the values of var2 are more than once in var1.

I am gonna try this, thank you :)
________________________________________
Van: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] namens Nick Cox [njcoxstata@gmail.com]
Verzonden: donderdag 14 april 2011 17:32
Aan: statalist@hsphsun2.harvard.edu
Onderwerp: Re: st: add up variable / quantile

gen var3 = var1 == var2

is certainly a good way to create a variable saying whether two
variables are the same. But what do you mean that "this is not
working"?

Note that -- necessarily -- this syntax compares values in the same
observation, and not in different observations.

gen var4 = var1 == var2[_n-1]

illustrates an extension which may be closer to what you seek.

Nick

On Thu, Apr 14, 2011 at 4:04 PM, Scharnigg, Stan (Stud. SBE)
<s.scharnigg@student.maastrichtuniversity.nl> wrote:
> I tried a different approach now. I created two new variables (var1, var2), and I want to use those
> two variables to create a third variable (var3). Var3 needs to be "1" if var1 has the same values as var2
>
> So I tried this:
> gen var3 = 0
> replace var3 = 1 if var1==var2
>
> However, this is not working. Is something like this possible in 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/

*
*   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/
```