Your code is generating so many warnings I suspect there is major issue with the starting data sets in general.
I suspect that your real issue starts with the previous error message:
NOTE: The data set DB_KC.fsk_transaction_alert has . observations and 9 variables.
ERROR: CLI execute error: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'XPKFSK_TRANSACTION_AL'. Cannot insert duplicate key in object
'FCFKC.FSK_TRANSACTION_ALERT'. The duplicate key value is (11342, 240418000042). :
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE APPEND used (Total process time):
Since the log shows no code between this error any your other error I suspect that some other macro code is attempting to use FCFKC.FSK_TRANSACTION_ALERT in creating or modifying seg_kc.FSK_TRANSACTION_ALERT. But since the first set has an error related to duplicate key values and failed that is likely highly related to the next error.
I suggest setting:
Options mprint ;
before re-running that macro to get more details of the code being generated.
