In SAS/ACCESS Interface to Impala, data with a 0.0000 value in the SAS data set loads into Impala and is stored as a NULL value.
This issue occurs because the value that attempts to be inserted is not actually held as 0.0000. Instead, the value is held as a very small number in exponential form. (For example, 9.537e-7.)
To circumvent this issue, use the Round function with an appropriate rounding value to make the value that is held equal to 0.
Here is an example:
var =round(var ,0.000001);