Hi all,
I am working on this program which is giving me outputs for some observations and null values for others. The programs works for values until 1.3 and after that does not produce a output.
Please try putting 1.3 (which works) and 1.4 (doesn't work) in where statement of proc sql.
Data A;
do x =0.1 to 100not working by 0.1;
output ;
end;
run;
proc sql;
select * from A where x = 1.4; /* Try the values of 1.3 and 1.4 */
quit;
This is caused by the fact that computers store numbers in floating point binary numbers. You cannot represent 1/10th exactly using binary digits. So eventually you see a difference between adding 0.1 multiple times and normal representation of the same number. Use the ROUND() or test for a very small absolute difference instead.
Data _null_;
do x =0.1 to 2 by 0.1;
if x in (1.3,1.4) then put x= 'Not rounded';
if round(x,0.1) in (1.3,1.4) then put x= 'Rounded' ;
end;
run;
This is caused by the fact that computers store numbers in floating point binary numbers. You cannot represent 1/10th exactly using binary digits. So eventually you see a difference between adding 0.1 multiple times and normal representation of the same number. Use the ROUND() or test for a very small absolute difference instead.
Data _null_;
do x =0.1 to 2 by 0.1;
if x in (1.3,1.4) then put x= 'Not rounded';
if round(x,0.1) in (1.3,1.4) then put x= 'Rounded' ;
end;
run;
Thanks!!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.