I need to have one numeric column newvar with max length of 12 and 2 decimal places PROC SQL;    CREATE TABLE newtable AS    SELECT       (CASE          WHEN oldvar=1 THEN oldvar2 * 123.45          WHEN oldvar=2 THEN oldvar2       END) newvar    FROM oldtable; QUIT; I've tried with newvar format=12.2 and DECIMAL(oldvar * 123.45,12,2) with no success.   ... View more