Convert Scientific Notations (e-07) into Decimal Notation

[Nihar Singh]

Hi All,

I have various observations in my dataset like- 1.40e+09, 1.57e-07.

How to convert these scientific notations into decimal notations?

[Carlo Lazzaro]

Nihar:
see -help format-.

[Nihar Singh]

HI Carlo,

I read the document. Thankyou!

I used the following command- tostring bse_firm_specific_volatility, generate(bse_firm_specific_volatility1) format (%9.0g). But erroe: "bse_firm_specific_volatility cannot be converted reversibly" is coming.

[William Lisowski]

You should not be converting your numeric data to strings. You should simply change the format used to display them.

. describe euros

Variable      Storage   Display    Value
    name         type    format    label      Variable label
------------------------------------------------------------------------------------------------
euros           double  %10.0g                

. list

     +-----------+
     |     euros |
     |-----------|
  1. | 1.401e+09 |
     +-----------+

. format %12.0f euros

. describe euros

Variable      Storage   Display    Value
    name         type    format    label      Variable label
------------------------------------------------------------------------------------------------
euros           double  %12.0f                

. list

     +------------+
     |      euros |
     |------------|
  1. | 1401234567 |
     +------------+

Another approach which is often helpful with financial data is to convert it from, for example, euros to millions of euros.

. generate euros_m = euros / 1000000

. describe euros_m

Variable      Storage   Display    Value
    name         type    format    label      Variable label
------------------------------------------------------------------------------------------------
euros_m         float   %9.0g                 

. list euros_m

     +----------+
     |  euros_m |
     |----------|
  1. | 1401.235 |
     +----------+

[Nihar Singh]

Thank you William. Changing the format of the display worked.