Re: st: How can I look up values from another dataset..?

[Nicholas Winter <nw53@cornell.edu>]

Sounds like a job for the -merge- command.

Nick Winter


At 03:30 PM 9/9/2003 +0100, you wrote:
> I have one dataset which includes the field postcode.
>
> I have a second dataset which contains just 2 columns: postcode and area
> code.
>
> I want to assign each observation in my first dataset to have an area code
> (using the postcode).
>
> If i were doing this in excel i could use the function "VLOOKUP",
> unfortunately there are so many postcodes that i would have to use 17
> worksheets for this exercise. Does anyone know how i could do this lookup in
> Stata..?
>
> Thanks in advance
>
> Lucy
>
>
>
>
>
> L C Morecroft
>
> Medical Statistician
>
> Trent Cancer Registry
> 5 Old Fulwood Road, Sheffield, S10 3TG
>
> Tel: 0114 226 3575
> Fax: 0114 226 3561
> website: www.trentcancer.nhs.uk
>
>
> *
> *   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/
--------------------------------------------------------
Nicholas Winter                           308 White Hall
Assistant Professor                       t:607.255.8819
Department of Government                  f:607.255.4530
Cornell University                      nw53@cornell.edu
Ithaca, NY 14853-7901       falcon.arts.cornell.edu/nw53 
*
*   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/