arina,
you can use the kountry command i specifically wrote for that purpose,
in stata type
-findit kountry-
install the command and read the help file.
rafal
On Mon, Jun 29, 2009 at 12:35 PM, Arina Viseth<[email protected]> wrote:
> 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.
>
> sincerely,
>
> Arina
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/