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
Applying weights to mixed-effects logistic regression modelHello Statalist, I am trying to add weights to my mixed-effects logistic regression model. I could …
fractional probit with sample selection using CMPHello everyone! I am planning to run a fractional response model with sample selection. I wonder if …
command tabcount is unrecognizedHi everyone, I'm learning stata these days. I was trying to use tabcount but I get the following err…
Reshaping data for tabplotArray Hello, How do I reshape the following data to be able to use the tabplot command? Basically I…
Matrix not found error after just listing the matrixDear All, Sorry for a very lengthy post, but I am trying to explain the problem comprehensively. I a…
Subscribe to:
Post Comments (Atom)
0 Response to How to avoid comma and rounding in numeric format
Post a Comment