topic Re: a 101 question in SAS Programming

a 101 question

runningneptune — Wed, 09 Dec 2020 16:52:40 GMT

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;

Re: a 101 question

yabwon — Wed, 09 Dec 2020 17:00:19 GMT

see this paper:

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

and try this:

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

Re: a 101 question

vellad — Wed, 09 Dec 2020 17:02:01 GMT

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

Re: a 101 question

runningneptune — Wed, 09 Dec 2020 18:38:39 GMT

Thank you mate! I learn something new.