SQL sum: avoid rounding

[Konkordanz]

Hi,

in my dataset Kredit1 I want to sum the values of the column c3 and want to copy the result into a new row of the same table. That works. But: The result has no or only one decimal-digit. The aim is: 3 decimal-digits.

I use the following code...is there a option for this code, which could help?

proc sql noprint; 
select sum(c3) into :Gem3 from Kredit1;
quit;

proc sql;
insert into KREDIT1 (NameBST,c3)
values ("Gem",&Gem3);
quit;

[PaigeMiller · Accepted solution]

Apply the desired format to the sum

Example:

proc sql noprint; 
select sum(c3) format=10.3 into :Gem3 from Kredit1;
quit;

[Konkordanz]

Thank you!