BookmarkSubscribeRSS Feed
sharon4pal
Obsidian | Level 7

 

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

1 REPLY 1
ballardw
Super User

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 510 views
  • 0 likes
  • 2 in conversation