05-10-2016 10:24 AM
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:
I need the exact number. What should I do. Please guide me.
Thank you in advance
05-10-2016 10:31 AM
Use a format long enough to hold the largest value. Currently I suspect your format for the variable is best8.
sum(total) as overalltotal format=best16.