a 101 question

[runningneptune]

Dear community,

I have a super simple question but could not figure out by my own, see below codes. Why I cannot get any record in data set "test"? This is so weird.

data A;
do v_gamma=0.7668,1,1.5,2,2.5,3,3.2749;
do v_rho=0 to 1 by 0.1;
do v_deltap=2,3,4,5;
do v_deltas=1,2,3,4,5;
v_tp1=0.5;
v_ts1=0.5;
v_alpha=0.05;
v_eps=1E-11;
output;
end;
end;
end;
end;
run;

data test;
set A;
where v_rho=0.8;
run;

[yabwon · Accepted solution]

see this paper:

https://support.sas.com/resources/papers/dealing-with-numeric-representation-error-in-sas-applicatio...

and try this:

data test;
set A;
where round(v_rho,0.1)=0.8;
run;

[runningneptune]

Thank you mate! I learn something new.

[vellad]

You can make it work using  

data test;
    set A;
    where round(v_rho,0.1)=0.8;
run;

The issue is related to rounding and the way computers internally store numeric values, specifically floating points.

See this thread for more info: Solved: Re: I meet with a problem of data values in do loo... - SAS Support Communities