Good Morning everybody,
I have a problem: importing data from an excel sheet to Stata will convert the variable to a string. To be clear: I use commas "," for thousands, and "." for decimals on excel. To convert string variables into numeric ones I use the following code
After using this code all the numbers are without any ",", as you can see.
The problem is that when I run a simple regress or calculate some summary statistics as mean then I have numbers without "," or any kind of signs.
PS. the regress is just an example.
Is there a way to have commas displayed in the summary statics of the regress functions (for instance for the coefficients)?
I have another question: as you can see below
One of the numbers is with exponential formatting and for confidence interval, this kind of formatting is again displayed. Is there a way to make it with the same format as the others?
I know it can be an outsider but I still need some time to get familiar with data analysis.
Thanks a lot to everybody for helping me.
Regards
I have a problem: importing data from an excel sheet to Stata will convert the variable to a string. To be clear: I use commas "," for thousands, and "." for decimals on excel. To convert string variables into numeric ones I use the following code
Code:
destring assets2010, replace ignore(",")
Code:
assets2010 4387459 1028048 655685 1011944 432152 507172 1552966 93974 2252309 983583 1826432
The problem is that when I run a simple regress or calculate some summary statistics as mean then I have numbers without "," or any kind of signs.
Code:
----------------------------------------------------------------------------
assets2010 | Coefficient Std. err. t P>|t| [95% conf. interval]
-------------+----------------------------------------------------------------
roaa2018 | 627404.9 3283442 0.19 0.849 -5871967 7126776
_cons | 5258159 3074135 1.71 0.090 -826901.9 1.13e+07
------------------------------------------------------------------------------
Is there a way to have commas displayed in the summary statics of the regress functions (for instance for the coefficients)?
I have another question: as you can see below
Code:
assets2010 392096 338992 603169 7259209 302621 500435 1066255 550826 2288256 428394 237235 3.330e+08 258911 1352623 1739526 618400
I know it can be an outsider but I still need some time to get familiar with data analysis.
Thanks a lot to everybody for helping me.
Regards

Comment