Pass Today's Day into a Proc SQL Query using a variable

[Kody_devl]

I have a series of queries that consecutively run using PROC SQL:

This query requires (one in the series) that I update the hardcode current day (today)('23Sep2016'd).

How can I insert a variable that automaitcally has today's date?

PROC SQL;

CREATE TABLE WORK.Roll_3 AS

t1.Loan_Number,

-(COUNT(t1.Loan_Number)) FORMAT=CHAR10. AS cnt

FROM WORK.LOAN_DETAIL_STATUS t1

INNER JOIN WORK.LOAN_DETAIL_SRCES t2 ON (t1.Out_Status_Day = t2.Source_Date_dte)

WHERE t1.Last_Stat = '*' and t1.Out_SYS_date <>'23Sep2016'd

GROUP BY

t1.Loan_Number,

QUIT;

Many thanks.

[LinusH]

Just add it to you select clause.
You may also consider using the automatic macro variable sysdate since it could be less resource consuming, especially in the where clause.

[Reeza]

It's either today() or date() can't remember at the moment. 

[Kody_devl · Accepted solution]

This works perfectly!  Thankyou

WHERE t1.Last_Stat = '*' and t1.Out_SYS_date <> today()