topic Re: SQL sum: avoid rounding in SAS Programming

SQL sum: avoid rounding

Konkordanz — Thu, 09 Sep 2021 11:33:24 GMT

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;

Re: SQL sum: avoid rounding

PaigeMiller — Thu, 09 Sep 2021 11:44:23 GMT

Apply the desired format to the sum

Example:

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

Re: SQL sum: avoid rounding

Konkordanz — Thu, 09 Sep 2021 11:59:23 GMT

Thank you!