RE: st: strgroup

[Emily Farchy <emily.farchy@sant.ox.ac.uk>]

Dear Dimitriy,

Thank you so much for your help. I am trying to match some badly spelled names.  They are all in the same variable, but over different periods.  In the end I tried to do it manually (see below) but even this doesn't seem to have worked and when I run it, for many of the obs it returns '0 changes made'  I copied and pasted from the cells so can't think that I have made a typo!

Any ideas?

*Badly named heads
*-----------------------------------------------------------------------------------------
replace off_name  = "Drs. Makmur Syahputra, Sh" if off_name=="H. Makmur Syah Putra, Sh, Mm"
replace off_name = "Drs. H. Risuddin" if off_name=="Risuddin"
replace off_name  = "Amru Helmy Daulay Sh" if off_name=="H Amru Helmy Daulay Sh"
replace off_name  = "Drs H Abdillah Se Ak Mba" if off_name=="Drs H Abdillah Se Ak. Mba"
replace off_name  = "Dr H Sutrisno Hadi Sp.Og" if off_name==" "
replace off_name  = "Drs Zulkarnain Nasution" if off_name=="Zulkarnain Nasution"
replace off_name  = "Kol Mar Dairus Apan" if off_name=="Kol Mar (Purn) Dairus Apan"
replace off_name  = "Kol Mar Dairus Apan" if off_name=="Darius Apan"
replace off_name  = "Drs H Syamsurizal" if off_name=="Drs H Syamsurial"
replace off_name  = "Drs Thamsir Rachman" if off_name=="Drs H Raja Tamsir Rahman"
replace off_name  = "T Azmun Jaafar Sh" if off_name=="H T Azmun Jafar"
replace off_name  = "H Arwin Sh" if off_name=="Arwin As Sh"
replace off_name  = "Drs Abdullah Hich" if off_name=="Drs H Abdullah .H"
replace off_name  = "Drs H A Madjid Mu'Az Mm" if off_name=="Drs H A. Madjid Mu'Az"| off_name=="Drs H A. Madjid Mu'Az Mm"
replace off_name  = "Dr H Zulfikar Achmad Se" if off_name=="Dr H Zulfikar Achmad"
replace off_name  = "Alex Noerdin" if off_name=="Ir H Alex Noerdin Sh."
replace off_name  = "Eddy Yusuf" if off_name=="Eddy Yusuf Sh Mm"
replace off_name  = "Drs Andi Ahmad Sampurna Jaya M Si." if off_name=="H Andy Achmad S Jaya. M.Si"
replace off_name  = "Drs Abdurachman Sarbini Sh" if off_name=="Abdurrachman Sarbini"
replace off_name  = "Drs Tatang Farhanul Hakim" if off_name=="Kol Inf H. Suliana Wirata Hadi Subrata" 
replace off_name  = "Itoch Tohija" if off_name=="Ir H M. Itoc Tochija Mm"
replace off_name  = "Drs Djasri St Mm." if off_name=="Drs Djasri St.Mm"
replace off_name  = "Bambang Bintoro Se" if off_name=="H Bambang Bintoro Se"
replace off_name  = "Ir Basuki Widodo" if off_name=="Ir H Basuki Widodo"
replace off_name  = "Probo Yulastoro" if off_name=="H Probo Yulastoro S Sos Mm"
replace off_name  = "Hendro Martojo" if off_name=="Drs Hendro Martojo Mm"
replace off_name  = "Dra Rustriningsih" if off_name=="Dra Hj Rustriningsih"
replace off_name  = "Hendy Boendoro Sh" if off_name=="H Hendy Boendoro Sh M Si"
replace off_name  = "Tasiman" if off_name=="H Tasiman S H."
replace off_name  = "H M Machroes Sh." if off_name=="H M Machroes S.H"
replace off_name  = "Drs Triono Budi Sasongko M Si" if off_name=="Drs Triyono Budi Sasongko"
replace off_name  = "Ir Bambang Guritno" if off_name=="H Bambang Guritno"



-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Dimitriy V. Masterov
Sent: 21 February 2011 19:07
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: strgroup

Emily,

It should work on a Mac. What do -di c(machine_type)- and -di c(os)- produce?

Alternatively, you could install a 32-bit version of Stata executable.
This is a bit of a pain. Instructions here:
http://statalist.1588530.n2.nabble.com/identifying-strings-that-differ-on-one-or-two-letters-td5755145.html#a5761453

Another approach is to describe (with examples) what you wish to
accomplish with strgroup. For example, reclink (from ssc) and soundex
have proven valuable in the past.

DVM
*
*   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/