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

RE: 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   RE: st: ST: populating a variable based on a second data set
Date   Wed, 25 Jun 2003 07:48:50 -0700

Many thanks.

Bayard



From: Ulrich Kohler
Subject: Re: st: ST: populating a variable based on a second data set

. 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

-- 
kohler@wz-berlin.de


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