Hello @JuanS_OCS @Kurt_Bremser Thank you for the feedback. I have included some more details. I have populated the grpmems canonical table with the right columns and in the right format. . as defined usingh the %defineidgrpcols macro. Here are the two scenarios which I tested: 1) Full code: /* Initialize the macro variables that create canonical tables. */ %mduimpc(); /* Create the grpmems table for user/groups association to add to Metadata. */ data &idgrpmemstbla; %defineidgrpmemscols; infile datalines delimiter=',' missover; input grpkeyid memkeyid; datalines; MYGROUP,MYID ; * Load the information from the work library into the metadata server. */; %mduimplb(); See attachment MDUIMPLB_error_log_1.txt for full error log. 2) I populated the idgrps and persons canonical tables, filtering them down to just the relevant user and group. Full code: /*To extract existing metadata content */ %mduextr(libref = work); /*Filter idgrps and person tables to include only relevant group(s) and user(s)*/ data work.person; set work.person(where=(name="MYID")); run; data work.idgrps; set work.idgrps(where=(name="MYGROUP")); run; /* Initialize the macro variables that create canonical tables. */ %mduimpc(); /* Create the grpmems table for user/groups association to add to Metadata. */ data &idgrpmemstbla; %defineidgrpmemscols; infile datalines delimiter=',' missover; input grpkeyid memkeyid; datalines; MYGROUP,MYID ; * Load the information from the work library into the metadata server. */; %mduimplb(); See attachment for MDUIMPLB_error_log_3.txt for full error log. I am not sure what I am missing in the code or process. Suggestions much appreciated.
... View more