proc sql date function

Nehcour0420 — Wed, 01 Aug 2012 00:45:36 GMT

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

Re: proc sql date function

art297 — Wed, 01 Aug 2012 01:00:13 GMT

I think that the same proc sql condition would be

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