Hi, Here is an example of the statements I am using (the percentages work for the output but not for the results): PROC SQL; CREATE TABLE SET100 AS SELECT DISTINCT A.YRY, A.MTM, A.ID, A.RES, A.PRES, (PRES * MoDays*24) as total_month, A.DRES/calculated total_month format percentn10.2 AS PTRES FROM SET00 A WHERE A.CRES>0 AND A.DRES>0 order by calculated ptres desc; QUIT; proc univariate data=SET100; var PTRES; run; ODS RTF CLOSE;
... View more