[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: match two datasets

From   Arina Viseth <arina@UDel.Edu>
Subject   st: match two datasets
Date   Mon, 29 Jun 2009 13:35:40 -0400 (EDT)

Dear Statalist,

I have two different lists of countries, list A, and list B (one has about 150 countries, the other about 200).

I would like to match list B with list A (list A is my mater list). The problem is that list B has countries that are named differently although they refer to the same countries of list A,(sometimes the difference is just "Bahamas, The" instead of "Bahamas, the"),  or it has countries that are not included in list A. 

So in order to join both lists,  I created a country code for list A, and use the function joinby code, unmatched(master) to match data from list B to list A. 

However, I have to check manually if list B does not contain a country that was named differently under list A, and then was automatically removed. 
If I do joinby code, unmatched(both), then I would have to check manually which countries belong to list A and which does not. 

My question is, would there be a quick and certain way to match data from both lists?

In advance, thank you very much for any your suggestions. 


*   For searches and help try:

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