Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: ST: populating a variable based on a second data set


From   "Webb.Bayard" <Bayard.Webb@igt.com>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: ST: populating a variable based on a second data set
Date   Tue, 24 Jun 2003 15:45:44 -0700

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index