SAS format Issue

[sumanthjbhargav]

Hi,

I am trying to take the sum ofa numerical variable but getting the values in exponential. I must retain the sum as whole number as it is because i need it for comparing.

data abc;
x = 9823748762398720570234;
run;

proc sql;
create table temp as
select sum(x)  from abc;
quit;

[ChrisHemedinger]

How about this:

proc sql;

create table temp as

select sum(x) as Sum format=32.  from abc;

quit;

Chris

[ballardw]

If your example is typical of your data then you are exceeding the precision of SAS variables, at least as documented in SAS 9.3.

[stat_sas]

The precision of floating-point values is accurate to approximately 15 digits.

http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#numvar.htm

[sumanthjbhargav]

Many thanks for the conclusion

[jakarman]

reading some old statistical books. make you data numbers to a converted offset position (1970's), sliders were seen, doing handwork understanding your data and tools.
The pitfall of working with big numbers is losing accuracy not notified.