I'm trying to create a table using proc sql with date(in DATE9. format) as on of the column. I'm trying to filter the data using where on the date column in the proc sql. I want to have today's date in the condition. My code looks like: PROC SQL; create table work.sheet as select a, b, date from library where date>= '02-01-2018' and date <= today(); quit; The error message says; SQL0440N No authorized routine named "TODAY" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884 it works well when I use, where date>= '02-01-2018' and date <= '05-31-2019'; Can someone help me on this? Thank you.
... View more
