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
