. use B, clear
. sort type
. save temp, replace
. use A, clear
. sort type
. merge type using B
The command -mmerge- by Jeroen Weesie allows to do this one single command.
regards
uli
Webb.Bayard wrote:
> Hi, I'm a new Stata user with a merge problem.
>
> I have one data set (call it A) with a variable that needs to be defined in
> terms of the observations in a second data set (B). I don't know if this
> can be done with a single command or if it needs to be programmed.
> Basically, B is a lookup table. I need to lookup the contents of an A var
> in B, and return the value of a different B var corresponding to the same
> data point.
>
> Thanks in advance for any suggestions.
>
> Bayard
>
>
> Example
> A =
> type
> 1 human
> 2 cat
> 3 human
> 4 dog
> 5 rat
> 6 cat
>
>
> B =
> type tail
> 1 human 0
> 2 cat 1
> 3 dog 1
> 4 rat 1
>
>
> AFTER OPERATION
> A =
> type tail
> 1 human 0
> 2 cat 1
> 3 human 0
> 4 dog 1
> 5 rat 1
> 6 cat 1
--
[email protected]
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
