Hello,
I have a dataset, it appears in Excel right like this
stkcd trdmnt msmvttl
000001 1991-12 2634210.72
000001 1992-12 5993999.81
000001 1993-12 6021490.04
000001 1994-12 4517599.33
000001 1995-12 3326125.61
000001 1996-12 17091009.31
000001 1997-12 35226928.99
000001 1998-12 23246669.44
000001 1999-12 27079731.76
When I copy it to Stata or import the Excel file it will be as shown below, in addition to the numbers are rounded if I convert it to Numeric, however, it is similar to Excel if it is listed as String.
stkcd trdmnt msmvttl
000001 1991-12 2,6e+06
000001 1992-12 6,0e+06
000001 1993-12 6,0e+06
000001 1994-12 4,5e+06
000001 1995-12 3,3e+06
000001 1996-12 1,7e+07
000001 1997-12 3,5e+07
000001 1998-12 2,3e+07
000001 1999-12 2,7e+07
Related Posts with How to avoid comma and rounding in numeric format
suest with "too many base levels specified"?Dear All, I was asked this question from a friend. The error message is Array Any suggestion on thi…
Measuring the % of variance by explanatory factors in regression modelsIs there any way in Stata 14 to measure the percentage of variance for a given IV. I came across an…
Testing coefficient equality in (subsample) panel data regressions?Dear All, Suppose that I have the following code, Code: webuse grunfeld, clear gen ind = company …
Help with Regression CommandsI am supposed to display a graph comparing the results by gender and students of multiple variables.…
Invalid Name Using ReplaceHello, I was trying to replace the value of some variables. My code is: replace a867_2900 = 375000…
Subscribe to:
Post Comments (Atom)
0 Response to How to avoid comma and rounding in numeric format
Post a Comment