Dear all,
A dataset with 11 variables was imported to STATA using File -> Import Excel spreadsheet. Then, Data -> Create or change data -> Convert variables from string to numeric was used.
Stata recognised two types of numeric variables: byte for dummy and double for other. Function "describe" identifies 184 observations, but a regression that I run provides me with only 142 observations.
Dataex reveals that some values were replaced into dots instead of numbers, however in the original excel file all values seem to be fine. It contains numerical values and there should not be any issues.
Could you please help me fix this problem?
I'm looking forward to any ideas on how it can be fixed
Related Posts with Convert variables to numeric results in data loss when a regression is run
Fixed, Random or Pool OLS.Hi, I have panel data containing firm observations for two years. I have to choose Panel model amon…
Problem with generating an instrumental variableHello, I’m using STATA 15 to generate a variable that will be used as an instrument in a regression.…
Formatting r(mean) for use in graphsHello, I am trying to automate the generation of graphs that highlight the coordinates where two li…
export F test of excluded instruments of 1st stage of 2SLSI want to export F test of excluded instruments of 1st stage of 2SLS using estout. Code: ivreg2 DV…
Extension of maximum number of variables by "maxvar" is not possible:I have Stata 15 with a Stata/SE license. So extension of memory space should be possible. However us…
Subscribe to:
Post Comments (Atom)
0 Response to Convert variables to numeric results in data loss when a regression is run
Post a Comment