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