topic Re: 10 Decimal value changed to Excel style value in SAS Data Management

10 Decimal value changed to Excel style value

imdickson — Tue, 18 Sep 2018 06:14:36 GMT

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?

Re: 10 Decimal value changed to Excel style value

Kurt_Bremser — Tue, 18 Sep 2018 06:31:58 GMT

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

Re: 10 Decimal value changed to Excel style value

imdickson — Tue, 18 Sep 2018 07:35:41 GMT

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.

Re: 10 Decimal value changed to Excel style value

ballardw — Tue, 18 Sep 2018 15:33:46 GMT

@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;

Re: 10 Decimal value changed to Excel style value

imdickson — Wed, 19 Sep 2018 09:56:52 GMT

I managed to solved this by using 20.10 FORMAT.

Thanks everyone