Dear All, I have this data set
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input str10 x double x1 float var3x2
"-0.0003*"   -.0003 10
"-0.0026**"  -.0026  5
"-0.0035***" -.0035  1
"-0.0117"    -.0117  0
"-0.0080*"    -.008 10
end
More specifically, I have data on x, and wish to obtain x1 and x2. x1 is the numerical part of x, and x2 is the significance level, denoted by stars, where *** is 1 percent significant (therefore x2=1), ** is 5 percent (therefore x2=5), and * is 10 percent (therefore x2=10). The fourth observation is insignificant, thus x2 = 0. Any suggestions are prreciated.