DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Contributor
Posts: 58
Accepted Solution

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

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.

 

 


Accepted Solutions
Solution
‎09-27-2016 03:05 PM
Contributor
Posts: 58

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

 

This works perfectly!  Thankyou

 

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

 

View solution in original post


All Replies
Super User
Posts: 5,257

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

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.
Data never sleeps
Super User
Posts: 17,865

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

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

Solution
‎09-27-2016 03:05 PM
Contributor
Posts: 58

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

 

This works perfectly!  Thankyou

 

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

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 251 views
  • 0 likes
  • 3 in conversation