Issue with the below code. The Report date is not getting matched in the below code. So, no rows are getting updated. %let REPORT_DATE=%sysfunc(putn(%sysevalf(%sysfunc(today()) - 1), yymmddd10.)); */to get yesterday date in YYYY-MM-DD format/* proc sql; connect to teradata (user="***********" password="*************" server="****************" mode=teradata); create table FLOW_YESTERDAY as select * from connection to teradata ( SELECT * FROM EDWDB.FLOW_ITD WHERE CAST(T1_DATE AS DATE) = &REPORT_DATE ); */T1_DATE='2021-03-23' gives the required output/* disconnect from teradata; quit; proc append base=SASVA.FLOW data=FLOW_YESTERDAY; run; Please provide a way around.
... View more