Hello Everyone,
I am new to SAS AML Solutions 7.1
I tried to run AGP but it keeps given me this error, kindly find the attached file for error logs
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: