I have a simple query where I'm summarizing some numerical fields: PROC SQL;
CREATE TABLE test AS
SELECT
SUM(column_a) AS column_a,
SUM(column_b) AS column_b,
SUM(column_a)/SUM(column_b) as Rate format=percent8.2
FROM
table1
GROUP BY
1
ORDER BY
1
;quit; This is an example of the results: column_a column_b Rate 8 99 0.00% Why aren't my percentage calculations working?
... View more