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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.