Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

RE: st: RE: RE: Need help with string observations


From   "David Radwin" <dradwin@mprinc.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: RE: Need help with string observations
Date   Tue, 26 Feb 2013 15:18:16 -0800 (PST)

Mike,

You'll want to look at the soundex function (-help soundex-). Also,
possibly Michael Blasnik's -reclink- from SSC if you want to
probabilistically match records across datasets.

David
--
David Radwin
Senior Research Associate
MPR Associates, Inc.
2150 Shattuck Ave., Suite 800
Berkeley, CA 94704
Phone: 510-849-4942
Fax: 510-849-0794

www.mprinc.com


> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of Michael Stewart
> Sent: Tuesday, February 26, 2013 3:03 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: RE: RE: Need help with string observations
> 
> Thank you David, Nick and Richard.All the recommendations are working
> Thanks a lot.
> 
> Can you suggest is there are any other modules to match names if they
> somewhat different like Richard & Ricard etc
> Thanks
> Mike
> 
> 
> On Tue, Feb 26, 2013 at 1:52 PM, David Radwin <dradwin@mprinc.com>
wrote:
> > Oops. I should have said the first and *second* words or first and
last
> > *names*. Sorry. But I think the syntax will work for you.
> >
> > David
> > --
> > David Radwin
> > Senior Research Associate
> > MPR Associates, Inc.
> > 2150 Shattuck Ave., Suite 800
> > Berkeley, CA 94704
> > Phone: 510-849-4942
> > Fax: 510-849-0794
> >
> > www.mprinc.com
> >
> >
> >> -----Original Message-----
> >> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> >> statalist@hsphsun2.harvard.edu] On Behalf Of David Radwin
> >> Sent: Tuesday, February 26, 2013 10:34 AM
> >> To: statalist@hsphsun2.harvard.edu
> >> Subject: st: RE: Need help with string observations
> >>
> >> Mike,
> >>
> >> There are several ways to do this. One is to just take the first and
> > last
> >> words and put a space in between:
> >>
> >> . gen firstlast = word(fullname, 1) + " " + word(fullname, 2)
> >>
> >> David
> >> --
> >> David Radwin
> >> Senior Research Associate
> >> MPR Associates, Inc.
> >> 2150 Shattuck Ave., Suite 800
> >> Berkeley, CA 94704
> >> Phone: 510-849-4942
> >> Fax: 510-849-0794
> >>
> >> www.mprinc.com
> >>
> >>
> >> > -----Original Message-----
> >> > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> >> > statalist@hsphsun2.harvard.edu] On Behalf Of Michael Stewart
> >> > Sent: Tuesday, February 26, 2013 10:08 AM
> >> > To: statalist
> >> > Subject: st: Need help with string observations
> >> >
> >> > Hi,
> >> >
> >> > Can you please help me with  String function
> >> > I have a list of patients and unfortunately some pts have their
names
> >> > recorded  in various formats like  James Edward ; James Edward H;
> >> > James Edward J   etc
> >> > Is it possible to write a code where the funcition  removes the
last
> >> > alphabet for the string if it is listed separately like
> >> >
> >> >  James Edward H--> James Edward
> >> >
> >> >
> >> > --
> >> > Thank you ,
> >> > Yours Sincerely,
> >> > Mike.
> >>
> >> *
> >> *   For searches and help try:
> >> *   http://www.stata.com/help.cgi?search
> >> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
> > *   http://www.ats.ucla.edu/stat/stata/
> 
> 
> 
> --
> Thank you ,
> Yours Sincerely,
> Mike.
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


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