SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

proc sql date function

Accepted Solution Solved
Reply
Contributor
Posts: 25
Accepted Solution

proc sql date function

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


Accepted Solutions
Solution
‎07-31-2012 09:00 PM
PROC Star
Posts: 7,467

Re: proc sql date function

Posted in reply to Nehcour0420

I think that the same proc sql condition would be

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

View solution in original post


All Replies
Solution
‎07-31-2012 09:00 PM
PROC Star
Posts: 7,467

Re: proc sql date function

Posted in reply to Nehcour0420

I think that the same proc sql condition would be

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 10617 views
  • 0 likes
  • 2 in conversation