Trying to figure out what the proper code to execute an if else from SAS EG with a value from a table. If you see below I've commented out the sas date value and I want to replace it with a select statement from a table. Basically I just want the execute to run when the today value -1 = the value in the table I created prior based on SASDate. I've tried creating a query from the snapshot_date table and using the select sql syntax and replacing the value but it keeps giving me an ERROR 388-185: Expecting an arithmetic operator. --------------------------------------------------------------------------------------------------- PROC SQL; CREATE TABLE SNAPSHOT_DATE AS SELECT PUT(DATEPART(MAX(AUDIT_BATCH_TS))-1,yymmddd10.) as 'Snapshot Date'n, today() as RunDate, DATEPART(MAX(AUDIT_BATCH_TS))-1 as SASDate FROM Ora_PSA.CC_ACTIVITY; ---------------------------------------------------------------------------------------------------------------------- data _null_; if (today()) =/*22256*/ then call execute( "PROC SQL; CREATE TABLE DIM_ASSIGNQUEUE AS SELECT DISTINCT Q1.ID as 'QUEUEID'n, Q1.NAME as 'Queue Name'n, Q1.DESCRIPTION as 'Queue Description'n, GROUPID FROM Ora_PSA.CC_ASSIGNQUEUE Q1 INNER JOIN (SELECT ID, MAX(AUDIT_BATCH_TS) AS MAXTS FROM Ora_PSA.CC_ASSIGNQUEUE GROUP BY ID) MAXQ ON MAXQ.ID = Q1.ID AND MAXQ.MAXTS = Q1.AUDIT_BATCH_TS; QUIT;" ); run;
... View more