proc sql date function

[Nehcour0420]

Hi,

I am working on transfer some DB2 code into proc sql and trying to handle some date calculate and process, the original db2 code is like:

dd.actual_date between DATE('20120801') - 3 DAYSAND DATE('20120801')

Just wondering if there is any way to achieve the same functionality using sas proc sql.

Thanks,

Eric

[art297 · Accepted solution]

I think that the same proc sql condition would be

dd.actual_date between '01AUG2012'd - 3 AND '01AUG2012'd