topic Pass Today's Day into a Proc SQL Query using a variable in SAS Programming

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

Kody_devl — Tue, 27 Sep 2016 17:15:42 GMT

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.

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

LinusH — Tue, 27 Sep 2016 17:32:26 GMT

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.

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

Reeza — Tue, 27 Sep 2016 17:47:53 GMT

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

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

Kody_devl — Tue, 27 Sep 2016 19:05:37 GMT

This works perfectly! Thankyou

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