[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: How can I look up values from another dataset..?
check out the merge command:
merge postcode using areacodedataset
----- Original Message -----
Sent: Tuesday, September 09, 2003 10:30 AM
Subject: st: How can I look up values from another dataset..?
> 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
> 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
> 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/
* For searches and help try: