Hi

I am fairly new to Stata, and have searched a lot on my issue but have not yet found a solution..

My issue is with destring of my variables. I have imported an excel sheets and some of my observations (due to currency conversion) contains a lot of decimals: eg.


FirmID fias
1 1604.26972699244
2 1454.1477388612

I then use the following destring command: (I have missing data as "n.a.")

destring fias, gen(fias_num) ignore("n.a.")

I get the following result:

FirmID fias_num
1 1.60e+14
2 1.45e+13

Hence that is a completely different number!!

Do anyone have a solution for this?

Fingers crossed
Rasmus