DATA Step, Macro, Functions and more

Specifying column width in Proc Sql

Reply
Contributor
Posts: 44

Specifying column width in Proc Sql

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

Super User
Posts: 5,424

Re: Specifying column width in Proc Sql

Posted in reply to danwarags

Usually SQL is not used for end user reports. But use the format= column option in the select statement.

Data never sleeps
Super User
Posts: 11,343

Re: Specifying column width in Proc Sql

Posted in reply to danwarags

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.

Ask a Question
Discussion stats
  • 2 replies
  • 415 views
  • 2 likes
  • 3 in conversation