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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.