Hello, I am using Stata 15.1. I have a string variable - student-teacher ratio (see data below). for some responses, they have the sign �� rather than a regualr expression. I think it should be a colon. Does anyone know how I can change �� into a colon or make it show as it should be rather than ��? Thanks!
----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str9 plc0107
"12:1"     
"16��1"    
"6.6:1"    
"3:1"      
"16.3:1"   
"10.7��1"  
"1173��93" 
"11��1"    
"23��1"    
"16.15��1" 
"1��14"    
"16.15��1" 
"15��1"    
"12��1"    
"1��13"    
"17.7:1"   
"16.3:1"   
"14.5��1"  
"1��19.6"  
"100��9"   
"9��1"     
"09��1"    
"12.5:1"   
"12��1"    
"1��10.4"  
"17.7:1"   
"15��1"    
"11:1"     
"11.4:1"   
"16.3:1"   
"9��1"     
"1��11"    
"18:1"     
"1��15"    
""         
""         
"6:5"      
"12:1"     
"11:1"     
"10.7��1"  
"14��1"    
"16.3:1"   
"12:1"     
"16.3:1"   
"1��14"    
"12��1"    
"10��1"    
"10��1"    
"16��1"    
"17:1"     
"6.6:1"    
"100��5.38"
"6.6:1"    
"12.8��1"  
"16.3:1"   
"7:1"      
"15.6��1"  
"11:1"     
"20��1"    
""         
"12.5:1"   
"5.5��1"   
"1��19.6"  
"18:1"     
"7:1"      
"1��15"    
"1��10.4"  
"11:1"     
"11��1"    
"15:1"     
""         
"12.5:1"   
"11��1"    
"16.8:1"   
"14.5��1"  
"1��11"    
"22��1"    
"10.7��1"  
"17:1"     
"21��1"    
"6.6:1"    
"7:1"      
"17:1"     
"7��1"     
"14��1"    
"1007��60" 
"12.5:1"   
"6:5"      
"18��1"    
"16.15��1" 
"11.6��1"  
"17:1"     
"3:1"      
"1��10.4"  
"13��1"    
"16��1"    
"7��1"     
"11:1"     
"14.5��1"  
"1��11.3"  
end
------------------ copy up to and including the previous line ------------------