10 Decimal value changed to Excel style value

[imdickson]

Hi everyone.

I am using SAS Data Integration Studio to load data from CSV into SAS DI Studio.

However, there are some data with 10 decimal place such as :

0.0000001919

When loading into SAS dataset, it will become excel style such as :
9E-7( and etc)

However, my CSV is still showing 0.0000001919.

I remain blank for Informat and format. Do take note that some of the numeric values have absolute number instead of decimal place.

Can anyone help me with this?

[Kurt_Bremser]

Assign it a best. format with a sufficient length, like best20.

[imdickson]

Hi Kurt. I've tried BEST20. for informat first, then format.

However, no matter assigning the informat or format, the value will remain

9.54E-7

Do take note that this is numeric in excel and SAS.

Seeking for your further help.

[ballardw]

---

@imdickson wrote:

Hi Kurt. I've tried BEST20. for informat first, then format.

However, no matter assigning the informat or format, the value will remain

9.54E-7

Do take note that this is numeric in excel and SAS.

Seeking for your further help.

---

I would really like to see the entire process as I suspect there is something missing from your description to turn "0.0000001919" into 9.54E-7.  I would believe 1.919E-7 (default to best8. format). You may want to use a format other than BEST as it has some issues regarding digits displayed for small values:

data example;
   x="0.0000001919";
   y=input(x,best20.);
   put y= best8. y= best15. y=  f14.10;

run;

[imdickson]

I managed to solved this by using 20.10 FORMAT.

Thanks everyone