09-27-2016 01:15 PM
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?
CREATE TABLE WORK.Roll_3 AS
-(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
09-27-2016 01:32 PM
Need further help from the community? Please ask a new question.