Hello! My data set includes a variable called price that is recorded as an interval (in most cases):
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str17 price
"$8.99 - $17.60" 
"$8.99 - $17.60" 
"$8.99 - $17.60" 
"$8.99 - $17.60" 
"$8.99 - $17.60" 
"$8.99 - $17.60" 
"$8.99 - $17.60" 
"$8.99 - $17.60" 
"$8.99 - $17.60" 
"19.95"          
"$6.99 - $12.55" 
"$6.99 - $12.55" 
"$6.99 - $12.55" 
"$6.99 - $12.55" 
"$7.47 - $14.69" 
"3.99"           
".31"            
".75"            
"$14.99 - $26.49"
"$14.99 - $26.49"
end
What will be the appropriate way to split this variable in to two numeric variables for the low and high values? Thank you in advance for help!