Dear experts,
I have a conversion error from my values from Excel to Stata.
The issue is that for some companies, Stata does not recognise the decimal numbers from Excel as such.
For example, you can see in the attached screenshots that the number 8,726 (in blue from Excel) is given in Stata as an incredibly high value of 8,726 * 10^15, while the other values from Excel were correctly transferred. Normally, therefore, 8726 should also have been given in Stata. Furthermore, you can see that the value 18,000 (from Excel) was only transferred to Stata with an 18.
Array
Array
I have already redrawn my sample from the company database called Dafne, but the problem recurs in all samples. So the problem must be with Stata.
Is anyone familiar with this conversion error and can you tell me what I did wrong and should do now?
Thank you very much
Related Posts with Conversion error with the numbers from Excel to Stata
Fuzzy match across multiple variables within a datasetI have a dataset of about 15000 observations of different patients, many of which are duplicates. Th…
Postdoctoral Employment opportunityDo you have experience in econometrics, Stata, and simulation techniques? We have an immediate openi…
Sum of squared deviationI have a dataset as follows: time return of stock a return of stock b eturn of stock c eturn of s…
Creating a graph with counts of IDs using 2 different requirementsHi everyone, Hoping to get some advice on how t ocreate a graph for my longitudinal patient panel t…
For loopI have a dataset with 30 variables containing one ICD-code each. I need to identify certain specific…
Subscribe to:
Post Comments (Atom)
0 Response to Conversion error with the numbers from Excel to Stata
Post a Comment