Equivalent of Vlookup for Stata
<p>I have two data sets, one where I have some 'raw' data and the other one containing 'results' of analysis of this 'raw' data.</p>

<p>I would like to find a way to operate an Excel equivalent <code>vlookup()</code> to retrieved the analysed data in the raw data.</p>

<p>My data set looks like as follows:</p>

<pre><code>RAW

John 12
Tim 13 
Steve 25 
Amy 47

ANALYSED

John Yes
Steve No
Tim Maybe
</code></pre>

<p>After the <code>vlookup</code>, my data would look like this:</p>

<pre><code>John 12 Yes
Tim 13 Maybe
Steve 25 No
Amy 47 NA
</code></pre>

<p>I haven't been very successful in finding a similar command on Stata - any help would be very appreciated!</p>