Hi Everyone,
I'm trying to update subset maps in the risk modeling solution. I'm on the step to configure joins.
This is the code that I've used:
proc sql; insert into apdm.Subset_Table_Join_Condition (Subset_Table_Join_Condition_Sk, Subset_From_Path_Sk, Join_Condition_Sequence_Number, Join_Type, Left_Table_Sk, Left_Column_Sk, Right_Table_Sk, Right_Column_Sk, created_dttm, created_by_user, last_processed_dttm, last_processed_by_user) values(1111114, 13, 1, 'LEFT', 1100013, 1100014, 1100015, 1100016, "%sysfunc(datetime(),DATETIME.)"dt, "&sysuserid", "%sysfunc(datetime(),DATETIME.)"dt,"sysuserid"); quit;
I get the error below:
ERROR: During insert: ERROR: insert or update on table "subset_table_join_condition" violates foreign key constraint "subset_table_join_condition_left_column_sk_fkey" DETAIL: Key (left_column_sk)=(1100014) is not present in table
I checked the table and I know for a fact that left_column_sk exists in the table. When I tried to omit it, it wouldn't let me do that either because of the null constraint. What am I doing wrong here? Thanks.
@sasprogramming
... View more