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

st: Merging by string variables

From   Meryle Weinstein <>
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


Meryle Weinstein, Ph.D.
Assistant Director
Institute for Education and Social Policy
New York University
665 Broadway, Suite 805
New York, NY 10012
212-995-4565 (fax)

*   For searches and help try:

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