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/
