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

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


From   Lucy.Morecroft@sth.nhs.uk
To   statalist@hsphsun2.harvard.edu
Subject   st: How can I look up values from another dataset..?
Date   Tue, 9 Sep 2003 15:30:21 +0100

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/



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