topic Following code is giving 0 obn anyone knows why%3F in SAS Programming

Following code is giving 0 obn anyone knows why%3F

Rudemulgga — Wed, 21 Jun 2023 03:53:35 GMT

data aa;
input a b;
c = b - a;
if c = 6.3;
datalines;
2.9 9.2
;
run;

Re: Following code is giving 0 obn anyone knows why%3F

Kurt_Bremser — Wed, 21 Jun 2023 04:30:26 GMT

Numbers are stored on computers in binary format. Most decimal fractions have no exact binary representations, which causes imprecision. Do a search for "SAS numeric precision" for the details.

When doing comparisons with decimal fractions, use the ROUND function or allow for fuzzyness.

Re: Following code is giving 0 obn anyone knows why%3F

Rudemulgga — Wed, 21 Jun 2023 04:46:41 GMT

Thanks Kurt!
Rounding before comparing is helpful.