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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Submit your idea!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.