Statalist


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

Re: st: match two datasets


From   Rafal Raciborski <rraciborski@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: match two datasets
Date   Tue, 30 Jun 2009 15:57:10 -0500

just to close the thread, arina's stata (10.1) was not properly
updated, after the update, -kountry- worked fine.

rafal





On Tue, Jun 30, 2009 at 2:39 PM, Arina Viseth<arina@udel.edu> wrote:
> Dear Rafal,
>
> Thank you so much for your command, it is indeed what I was looking for.
>
> After standardizing the list of countries by doing "kountry country, from(other) marker", and then recoding the names that failed to standardize by using kountryadd, I reran kountry with the stuck option but then I get a message that says: "unrecognized command:  label", especially three countries for which _ISO3N_ is missing (Kosovo, Montenegro and Taiwan).
>
> I am not sure what I should do next: could you please help me in this case?
>
> Again, thank you very much, I am very grateful for any of your suggestions.
>
> Sincerely,
> Arina
>
>
>
> _ISO3N_
> ---- Original message ----
>>Date: Mon, 29 Jun 2009 13:32:28 -0500
>>From: owner-statalist@hsphsun2.harvard.edu (on behalf of Rafal Raciborski <rraciborski@gmail.com>)
>>Subject: Re: st: match two datasets
>>To: statalist@hsphsun2.harvard.edu
>>
>>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<arina@udel.edu> 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/
>
> *
> *   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/



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