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
Usually SQL is not used for end user reports. But use the format= column option in the select statement.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.