topic why the numeric value is different between Teradata and SAS? in SAS Data Management

why the numeric value is different between Teradata and SAS?

Jade_SAS — Mon, 23 Apr 2018 13:06:11 GMT

Hi All,

I have a column value in Teradata which is -999999999992240155, while the corresponding value in SAS is -999999999992240128.

Any insights why the values are different?

BTW, the data type in Teradata is decimal(18,0), the data type in SAS is numeric and format=19.

Thank you!

Jade

Re: why the numeric value is different between Teradata and SAS?

Kurt_Bremser — Mon, 23 Apr 2018 13:15:44 GMT

All numbers in SAS dataset are stored in 8 bytes, real format (mantissa + exponent). Or less, if the length is reduced with a length statement.

That means that SAS can reliably store around 15 decimal digits. Any further digits will be lost or changed.

For further information, google for "sas numerical precision".

Re: why the numeric value is different between Teradata and SAS?

Jade_SAS — Mon, 23 Apr 2018 13:49:00 GMT

Thank you so much KurtBremser! So the value -999999999992240155 is out of the valid range of SAS, right?

Is there any work around to deal with this situation? Or there is nothing we can do with it?

Thanks,

Jade

Re: why the numeric value is different between Teradata and SAS?

Kurt_Bremser — Mon, 23 Apr 2018 13:52:54 GMT

Usually, when one encounters numbers with that many digits, they are not actual numbers, but some kind of code, in which case they should be kept in strings (character).

Keep in mind that the 15 digits of SAS can store the GNP of the US down to dimes, so that's sufficient for statistics.

Re: why the numeric value is different between Teradata and SAS?

Jade_SAS — Mon, 23 Apr 2018 15:01:04 GMT

Thank you!