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

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

From   Nicholas Winter <>
Subject   Re: st: How can I look up values from another dataset..?
Date   Wed, 10 Sep 2003 12:25:05 -0400

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

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

Thanks in advance


L C Morecroft

Medical Statistician

Trent Cancer Registry
5 Old Fulwood Road, Sheffield, S10 3TG

Tel: 0114 226 3575
Fax: 0114 226 3561

*   For searches and help try:
Nicholas Winter 308 White Hall
Assistant Professor t:607.255.8819
Department of Government f:607.255.4530
Cornell University
Ithaca, NY 14853-7901
* For searches and help try:

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