Making language of the String Var Observations Consistent

[Muhammad Saleh]

Hi,
I have 149 countries 63000 development projects data. A string variable with Location Name has few correctly typed enteries but most of the enteries are like this WilÄYat-E BaghlÄN or WilÄYat-E KÄPÄ«SÄ and San AndréS Sotavento. How can I change these string obsrvations to properly spelled names like San Andre Sotavento?

[Andrew Musau]

Provide a dataex with some examples.

dataex location_name

and copy and paste the output here.

[Muhammad Saleh]

* Example generated by -dataex-. To install: ssc install dataex
clear
input str78 place_name
"Afghanistan"                    
"Afghanistan"                    
"Panjshir"                       
"WilÄYat-E BaghlÄN"        
"Zabul"                          
"Herat"                          
"WilāYat-E JowzjÄ N"        
"NangarhāR"                   
"WilāYat-E LaghmÄ N"        
"Badakhshan"                     
"WilÄ Yat-E NÄ«MrÅ Z"      
"WilÄ Yat-E GhaznÄ«"         
"Kunduz"                         
"Ghowr"                          
"Kabul"                          
"Paktia"                         
"WilÄ Yat-E KÄPÄ«SÄ"   
"WilÄ Yat-E LÅGar"          
"Sar-E Pul"                      
"Balkh"                          
"Daykundi"                       
"SamangÄN"                    
"WilÄ Yat-E PaktÄ«KÄ"     
"VelÄ Yat-E NÅ«RestÄN"    
"Badghis"                        
"WilÄ Yat-E BÄMyÄN"      
"Helmand"                        
"WilÄYat-E TakhÄR"         
"WilÄYat-E Kunaá¹"        
"Faryab"                         
"ParwÄN"                      
"KandahÄR"                    
"Wardak"                         
"Farah"                          
"OrÅ«ZgÄN"                  
"VelÄYat-E Khowst"            
"Gardez"                         
"Taloqan"                        
"Band-E DarūNṯAh"        
"Mehtar LÄM"                  
"Mazari Sharif"                  
"Khuram Wa SÄR BÄGh"       
"Jalalabad"                      
"QalÄT"                       
"Ghazni"                         
"Kabul"                          
"Qizil Qal‘Ah"              
"Charikar"                       
"Naghlu"                         
"ShibirghāN"                  
"Pul-E Khumrī"                
"Kandahar"                       
"Kunduz"                         
"ḨAīRatāN"            
"KaldÄ R"                      
"ImÄM ÅÄḩIb"       
"ḨAẕRat-E SulţāN"
"Aybak"                          
"Kunduz"                         
"Khulm"                          
"Puli Khumri"                    
"WilÄYat-E LÅ Gar"          
"Afghanistan"                    
"ParwÄN"                      
"WilÄYat-E BÄMyÄN"      
"Badakhshan"                     
"WilÄYat-E KÄPÄ«SÄ"   
"Kabul University"               
"Kandahar University"            
"Takhar University"              
"Kabul"                          
"KalakÄN"                     
"ImÄM ÅÄḩIb"       
"MÄ«R Bachah KÅṯ"      
"SÄLang"                      
"Jabal Saraj"                    
"FaÄ«áºÄBÄD"         
"Jabal Saraj"                    
"Kabul"                          
"KalakāN"                     
"Fayzabad"                       
"Kunduz"                         
"Shakar Darah"                   
"KhinjāN"                     
"BagrÄM"                      
"Taloqan"                        
"HijÄ N"                       
"KalafgÄ N"                    
"Qizil Qalâ Ah"              
"SÄ Lang-E ShamÄ LÄ«"      
"Ali Abad"                       
"Kishim"                         
"KhinjÄ N"                     
"Baghlan"                        
"Pul-E Khumrī"                
"Puli Khumri"                    
"TÄ LuqÄ N"                  
"Kunduz"                         
"Qarah BÄGh"                  
"ParwÄN"                      
end

[Andrew Musau]

Thanks for the data example. I am not sure that this solves your issue as I do not know what the final names need to be. One way would be to build a dictionary and substitute the unwanted characters, but this will give you all ASCII characters.

g wanted = proper(ustrto(ustrnormalize(place_name , "nfd"), "ascii", 2))

Res.:

. l, sep(0)

     +---------------------------------------------+
     |            place_name                wanted |
     |---------------------------------------------|
  1. |           Afghanistan           Afghanistan |
  2. |           Afghanistan           Afghanistan |
  3. |              Panjshir              Panjshir |
  4. |     WilÄYat-E BaghlÄN     Wilayat-E Baghlan |
  5. |                 Zabul                 Zabul |
  6. |                 Herat                 Herat |
  7. |   WilāYat-E JowzjÄ N    Wilayat-E Jowzja N |
  8. |            NangarhāR             Nangarhar |
  9. |   WilāYat-E LaghmÄ N    Wilayat-E Laghma N |
 10. |            Badakhshan            Badakhshan |
 11. |   WilÄ Yat-E NÄ«MrÅ Z    Wila Yat-E Namra Z |
 12. |    WilÄ Yat-E GhaznÄ«     Wila Yat-E Ghazna |
 13. |                Kunduz                Kunduz |
 14. |                 Ghowr                 Ghowr |
 15. |                 Kabul                 Kabul |
 16. |                Paktia                Paktia |
 17. |    WilÄ Yat-E KÄPÄ«SÄ     Wila Yat-E Kapasa |
 18. |      WilÄ Yat-E LÅGar      Wila Yat-E Lagar |
 19. |             Sar-E Pul             Sar-E Pul |
 20. |                 Balkh                 Balkh |
 21. |              Daykundi              Daykundi |
 22. |              SamangÄN              Samangan |
 23. |   WilÄ Yat-E PaktÄ«KÄ    Wila Yat-E Paktaka |
 24. |  VelÄ Yat-E NÅ«RestÄN   Vela Yat-E Narestan |
 25. |               Badghis               Badghis |
 26. |     WilÄ Yat-E BÄMyÄN     Wila Yat-E Bamyan |
 27. |               Helmand               Helmand |
 28. |      WilÄYat-E TakhÄR      Wilayat-E Takhar |
 29. |      WilÄYat-E Kunaá¹       Wilayat-E Kunaa |
 30. |                Faryab                Faryab |
 31. |                ParwÄN                Parwan |
 32. |              KandahÄR              Kandahar |
 33. |                Wardak                Wardak |
 34. |                 Farah                 Farah |
 35. |              OrÅ«ZgÄN               Orazgan |
 36. |      VelÄYat-E Khowst      Velayat-E Khowst |
 37. |                Gardez                Gardez |
 38. |               Taloqan               Taloqan |
 39. |    Band-E DarūNṯAh       Band-E Daranaah |
 40. |            Mehtar LÄM            Mehtar Lam |
 41. |         Mazari Sharif         Mazari Sharif |
 42. |    Khuram Wa SÄR BÄGh    Khuram Wa Sar Bagh |
 43. |             Jalalabad             Jalalabad |
 44. |                 QalÄT                 Qalat |
 45. |                Ghazni                Ghazni |
 46. |                 Kabul                 Kabul |
 47. |        Qizil Qal‘Ah          Qizil Qalaah |
 48. |              Charikar              Charikar |
 49. |                Naghlu                Naghlu |
 50. |           ShibirghāN            Shibirghan |
 51. |         Pul-E Khumrī          Pul-E Khumra |
 52. |              Kandahar              Kandahar |
 53. |                Kunduz                Kunduz |
 54. |          ḨAīRatāN              Aaaratan |
 55. |               KaldÄ R               Kalda R |
 56. |          ImÄM ÅÄḩIb            Imam Aaaib |
 57. | ḨAẕRat-E SulţāN       Aaarat-E Sulaan |
 58. |                 Aybak                 Aybak |
 59. |                Kunduz                Kunduz |
 60. |                 Khulm                 Khulm |
 61. |           Puli Khumri           Puli Khumri |
 62. |      WilÄYat-E LÅ Gar      Wilayat-E La Gar |
 63. |           Afghanistan           Afghanistan |
 64. |                ParwÄN                Parwan |
 65. |      WilÄYat-E BÄMyÄN      Wilayat-E Bamyan |
 66. |            Badakhshan            Badakhshan |
 67. |     WilÄYat-E KÄPÄ«SÄ      Wilayat-E Kapasa |
 68. |      Kabul University      Kabul University |
 69. |   Kandahar University   Kandahar University |
 70. |     Takhar University     Takhar University |
 71. |                 Kabul                 Kabul |
 72. |               KalakÄN               Kalakan |
 73. |          ImÄM ÅÄḩIb            Imam Aaaib |
 74. |     MÄ«R Bachah KÅṯ        Mar Bachah Kaa |
 75. |                SÄLang                Salang |
 76. |           Jabal Saraj           Jabal Saraj |
 77. |            FaÄ«áºÄBÄD              Faaaabad |
 78. |           Jabal Saraj           Jabal Saraj |
 79. |                 Kabul                 Kabul |
 80. |              KalakāN               Kalakan |
 81. |              Fayzabad              Fayzabad |
 82. |                Kunduz                Kunduz |
 83. |          Shakar Darah          Shakar Darah |
 84. |              KhinjāN               Khinjan |
 85. |                BagrÄM                Bagram |
 86. |               Taloqan               Taloqan |
 87. |                HijÄ N                Hija N |
 88. |             KalafgÄ N             Kalafga N |
 89. |         Qizil Qalâ Ah         Qizil Qala Ah |
 90. |   SÄ Lang-E ShamÄ LÄ«    Sa Lang-E Shama La |
 91. |              Ali Abad              Ali Abad |
 92. |                Kishim                Kishim |
 93. |              KhinjÄ N              Khinja N |
 94. |               Baghlan               Baghlan |
 95. |         Pul-E Khumrī          Pul-E Khumra |
 96. |           Puli Khumri           Puli Khumri |
 97. |             TÄ LuqÄ N             Ta Luqa N |
 98. |                Kunduz                Kunduz |
 99. |            Qarah BÄGh            Qarah Bagh |
100. |                ParwÄN                Parwan |
     +---------------------------------------------+

.

[Muhammad Saleh]

Thanks alot. This was really helpful. Stay blessed!

[Luana Monteiro Barros]

Hi!

I'm experiencing the same issue but the command doesn't work, I think because my version of STATA is the 13. Any hints of how to normalize the variables names?