proc copy causes decimal value change?

ThomasH — Wed, 06 May 2009 09:16:56 GMT

Dear all,

I am facing an unexpected issue here.

There's field X (decimal 7.2) a in a DB/2 database, which contains the value 0.01.

Once I run a proc copy into a SAS dataset (also decimal 7.2), the value is changed to 0.00999...8.

Why does this happen? It does not behave like this for e.g. 100.00.

Thanks,
Thomas

Re: proc copy causes decimal value change?

Doc_Duke — Wed, 06 May 2009 12:18:20 GMT

0.01 and 0.00999... represent the same real number.

SAS does not store decimal numbers exactly (unlike, say, COBOL). It stores all numbers as real numbers. A base-10 decimal number cannot be represented exactly in a base-2 system (integers can be represented exactly).

There are also a couple of standards for the internal structure of a real number. There is possibility that DB/2 and SAS use different standards, which could exacerbate this problem.

To really tease it out you will have to read the "fine print" in both DB/2 and SAS for numeric representation.

Doc Muhlbaier
Duke

topic Re: proc copy causes decimal value change? in SAS Programming

proc copy causes decimal value change?

Re: proc copy causes decimal value change?