hi, I am using proc sql to divide two variables where the numerator is zero and the answer should be zero but I get a non zero number. The value of 'Sum_weight' is zero for a particular country and when I divide it by sum_pieces, the result should be zero: 0/number=0 PROC SQL; CREATE TABLE TEST AS SELECT ORIG_COUNTRY,QUARTER, SUM(GROSS_WEIGHT_KG) AS SUM_WEIGHT LABEL="SUM OF KG_WEIGHT" FORMAT=8.0, CALCULATED SUM_WEIGHT/ CALCULATED SUM_PIECES AS AWPP FORMAT=8.2 FROM OAPQ1Q2 GROUP BY ORIG_COUNTRY ,QUARTER; QUIT; Thank you in advance.
... View more
