Specifying column width in Proc Sql

[danwarags]

Hello Everyone,

I am trying to do proc sql to sum up a variable which has big numbers. The output rounds up the number. For example if my number is 618155640, the output shows as 6.1816E8. I need the exact number not the round up number in the output. What should I do. 

proc sql;
select sales,
sum(total) as overalltotal
from table
group by sales;
run;

The output sums up the total variable by sales and gives the output as below:

sales     overalltotal

Canada  6.1816E8

Europe   7.1888E8

Asia        1.6888E8

....

.....

etc. 

I need the exact number. What should I do. Please guide me.

Thank you in advance

[LinusH]

Usually SQL is not used for end user reports. But use the format= column option in the select statement.

[ballardw]

Use a format long enough to hold the largest value. Currently I suspect your format for the variable is best8.

Try

sum(total) as overalltotal format=best16.