Hi, I made up a dataset and ran your code. I don't have the problem you described and I ran the code in EG4.3 data test; input MeasureCount HourDefferedCount; cards; 1          3 2          4 3          1 0          5 1          6 0          1 1          2 1          3 0          4 1          5 0          6 1          7 ; proc sql;   select /* 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            from test as t1; quit; The SAS System TC_Tasks TC_Tasks_Met TC_Tasks_Met1 11 3 0.27272727 and your code is the same as proc sql;   select /* 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 */             calculated TC_Tasks_Met            / calculated TC_Tasks FORMAT=BEST10.9 LABEL="TC_Tasks_Met1" AS TC_Tasks_Met1   from test as t1; quit; Linlin ... View more