Using SAS EG 4.3 when I go to divide the two columns the results returned is always zero. I've tried different formats, etc. However the same two columns can be added, subtracted, multiplied no issues. See code and output below for details. Thanks in advance. Code: t1.Region, /* TC_Tasks */ (SUM(t1.MeasureCount)) FORMAT=11. LABEL="TC_Tasks" AS TC_Tasks, /* TC_Tasks_Met */ (SUM(CASE WHEN t1.HourDefferedCount <= 4 And MeasureCount = 1 THEN 1 ELSE 0 END)) FORMAT=11. LABEL="TC_Tasks_Met" AS TC_Tasks_Met, /* TC_Tasks_Met1 */ ((SUM(CASE WHEN t1.HourDefferedCount <= 4 And MeasureCount = 1 THEN 1 ELSE 0 END)) / (SUM(t1.MeasureCount))) FORMAT=BEST10.9 LABEL="TC_Tasks_Met1" AS TC_Tasks_Met1, TC_Tasks TC_Tasks_Met TC_Tasks_Met1 594 492 0 1805 1275 0 1791 1242 0 568 446 0 2462 1656 0
... View more