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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: