topic Dynamic SQL error in SAS Data Management

Dynamic SQL error

Sang90 — Mon, 09 Sep 2019 14:30:22 GMT

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

Re: Dynamic SQL error

SASKiwi — Mon, 09 Sep 2019 20:25:08 GMT

You have any extra semicolon on your query that could be removed. Don't know if that is causing the error.

Re: Dynamic SQL error

Sang90 — Mon, 09 Sep 2019 20:28:44 GMT

If i remove the semicolon, I am getting a SAS error like "expecting ;". So
i provided two semicolons

Re: Dynamic SQL error

SASKiwi — Mon, 09 Sep 2019 23:46:44 GMT

Might help to post the complete SAS log but specify - options mprint; - before running the program so the macro reference &ACCSLS resolves.