topic Re: proc sql rounding percentage no decimals in SAS Programming

proc sql rounding percentage no decimals

metallon — Tue, 03 May 2016 14:18:38 GMT

Hi SAS Experts,

I looked at the round function explanation and read that a ,1 should result in no decimals but my calculation reads 100,0 now and not just 100.

proc sql ;
CREATE TABLE mytable AS
SELECT
ROUND((SUM(numberA)*100)/SUM(numberB),1) AS percent_ab
FROM aaaa;
QUIT;

Re: proc sql rounding percentage no decimals

ballardw — Tue, 03 May 2016 14:32:26 GMT

Not quite sure exactly what you mean by "calculation reads 100,0"

Round is applied AFTER the results of

(SUM(numberA)*100)/SUM(numberB)

The FORMAT of the varaible percent_ab could be forcing the appearance of decimals. If the format is something like 5.1 it will force the appearance of 1 decimal, showing a 0 when none are actually present.

Re: proc sql rounding percentage no decimals

Reeza — Tue, 03 May 2016 15:46:28 GMT

Well it's rounded but you're looking to control the display.

proc sql ; 
CREATE TABLE mytable AS
SELECT 
            ROUND((SUM(numberA)*100)/SUM(numberB),1) AS percent_ab format=8.
      FROM aaaa;
QUIT;