I want to create a new variable and return a 1 when Date1 is greater than Date2 and have it formatted as a numeric. PROC SQL; CREATE TABLE Direct AS SELECT RECEIPTS.* ,Case When DATE1 GT Date2 then '1' ELSE '0' end as Date_Compare format=comma8.2 FROM RECEIPTS QUIT;
... View more
