Ah good point. I tried using the trunc function instead but got the same error proc sql;
connect to oracle;
create table MRSA as select * from connection to oracle
(
select distinct
c.MRN,
a.account_num, a.discharge_date,
b.collect_date, a.admit_date
from table1 a,
table2 b,
table3 c
where a.td_patient_id=b.td_patient_id and
b.td_patient_id=c.td_patient_id and
0 <= (trunc(b.collect_date, 'DDD') - trunc(a.admit_date, 'DDD')) <= 2 and
trunc(a.admit_date, 'DDD') >= '1-Jan-2012' and
trunc(a.admit_date, 'DDD') <= '1-Jan-2012'
);
disconnect from oracle;
quit;
... View more