Hi, proc sql; create table snp as select sum(Amount) as amt from tbl group by prdct quit; When i am summing the amount when the sum value is zero it's generating exponential value. what's causing the problem I have amounts like below Amount 208990.99 547244.6 91914.11 -208990.99 -91914.11 -547244.6 I used round function to overcome the problem but curious what caused the problem and using the round function appropriate solution? This is what i used proc sql; create table snp as select round(sum(Amount),0.01) as amt from tbl group by prdct quit;
... View more