SAS: Cannot use where or if condition for specific variable.

Question

I have a dataset which has a variable. I could do proc freq to show following table:

However I would like to output the observations were serumt=0.3:

data new;
set AIM12_OAW;
where serumt=0.3;
run;

I got error message as following:

NOTE: No observations were selected from data set WORK.AIM12_OAW. NOTE: There were 0 observations read from the data set WORK.AIM12_OAW.WHERE serumt=0.3;

I tried

where serumt=0.21

still no observations. The weird thing was if I did

where serumt=0.12

it would output one observation (should be 6).

If I did

proc freq data=aim12_onw;
table serumt;
by serumt;
run;

The output would be:

I cannot understand why the variable serumt could not be selected by where or if statement.

I did check the format of serumt. It looks normal for me.

I have no idea how to deal with this variable. Thank you so much for comments.

user667489 user667489 · Accepted Answer · 2016-09-16T22:14:56

Sounds like it might be a floating point precision issue - try something like

where round(serumt,0.01) = 0.30.

SAS: Cannot use where or if condition for specific variable.

1 Answers