Proc expand generate weird value

hhchenfx — Wed, 01 Nov 2023 16:44:13 GMT

Hi Everyone,

I use proc expand to get Max value of price. I know for sure that, the max value of price is 147212 and proc expand return the same value.

proc expand data=M1 out=M1;
by tic;
convert price=price_top_&window/transformout=(MOVmax &window );
run;

However, when I check the condition below, SAS doesn't return top=1 for the record with highest price.

if price = price_top_&window then top=1;

After some checking, it turns out that, some how the price_top_&window is fractional greater than 147212.

When I take Price - price_top_&window, SAS return value -2.91038E-11, which is -0.0000000000291038

All of my data are integer.

I wonder how that happens and how to fix it.

Thank you,

Re: Proc expand generate weird value

Reeza — Wed, 01 Nov 2023 16:57:58 GMT

Numeric Precision issue.

if round(price,1) = round(price_top_&window, 1) then top=1;

Lookup the round function to find the nearest level of precision that you would like to match on.

topic Re: Proc expand generate weird value in SAS Programming

Proc expand generate weird value

Re: Proc expand generate weird value