I am trying to get the sum of two columns from a table called account sales (ACC_SLS) but i am getting sqlcode 098 in sas log. SAS logic PROC DB2EXT OUT=UNBSALE; SELECT A.ACC_NO AS ACCNO, SUM(SLS_FUE_GRS_AMT) AS FULGRS, SUM(SLS_OTH_GRS_AMT) AS OTHGRS FROM &ACCMST AS A LEFT OUTER JOIN &ACCSLS AS B ON A.ACC_NO=B.ACC_NO WHERE (A.ACC_ACC_STS_CD = 'A' AND A.ACC_BLG_TSM_TYP = 'B' AND B.ACC_CYC_NO = +19 AND B.WK_INV_DT = '9999-12-31') GROUP BY A.ACC_NO ORDER BY 1;; RUN; SAS error: DB2 WARNING: RESULT OF SQL STATEMENT: DSN00098W A DYNAMIC SQL STATEMENT ENDS WITH A SEMICOLON A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS: ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0 SQLCODE: 98 SQLSTATE: 01568 SQLERRP: DSNHTOKR
... View more