Statalist


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

st: Merging by string variables


From   Meryle Weinstein <mgw216@nyu.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: Merging by string variables
Date   Tue, 1 Dec 2009 09:33:09 -0500

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/



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