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.
This works perfectly! Thankyou
WHERE t1.Last_Stat = '*' and t1.Out_SYS_date <> today()
It's either today() or date() can't remember at the moment.
This works perfectly! Thankyou
WHERE t1.Last_Stat = '*' and t1.Out_SYS_date <> today()
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.