Hello, I have little to no experience using SAS tool, but need to modify some prewritten code to utilise my employers automation capabilities with the code. Each morning I am required to produce a sample file and I am hoping to automate this process. There are two variables declared at the start of the SAS code: rsubmit; %let MinTxnDate='05MAR2018'; %let MaxExclusiveTxnDate='06MAR2018'; Further down the code proc sql is used to set filter: select * from COMPANY.TABLE with (nolock) where transactiondate >= &MinTxnDate. and transactiondate < &MaxExclusiveTxnDate. -- As things stand, I have to modify the dates each morning. The MinTxnDate should be yesterday, and Max today. Given that I want to automate this code, how would I set the MinTxnDate and Maxdate to the dates required? Played around with eval sysdates but not having much luck, but as I say I have never used SAS before this.
... View more