Statalist


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

Re: st: Merging by string variables


From   Eric Booth <ebooth@ppri.tamu.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Merging by string variables
Date   Tue, 1 Dec 2009 09:06:50 -0600

>
>

This is useful:

findit reclink


Eric

__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754
On Dec 1, 2009, at 8:33 AM, Meryle Weinstein wrote:

> I have two datasets that Im trying to merge by the following string
> variables:  agencyname sitename siteaddress.  There are slight differences
> in the datasets, particularly in the agencyname and sitename variables so
> I‚m having trouble merging the two datasets. The problem seems to be that
> the agencyname differs slightly in each of the datasets.  For example 
> 
> Dataset2                                                     dataset2
> 68th precinct youth council inc                              68th precinct
> youth council, inc.
> action center for education and community development, inc   action center
> for education and community development-ps 106
> amistad child day care and family center inc                 amistad early
> childhood educational center inc
> 
> Any suggestions on a way to merge by these three variables would be
> appreciated.
> 
> Thanks.
> 
> Meryle Weinstein, Ph.D.
> Assistant Director
> Institute for Education and Social Policy
> New York University
> 665 Broadway, Suite 805
> New York, NY 10012
> 212-998-5817
> 212-995-4565 (fax)
> 
> 
> 
> 
> 
> *
> *   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