Hello, Great thanks for your prompt response on this. What we are trying to achieve is following: 1.There is a users group in LDAP. Ex: abcd group containing user1, user2,user3, and user4. 2. These 4 users who are part of this abcd group will be extracted into a txt file(using unix script) which then will be used to create a SAS data set. Ex: abcd.sas7bdat looks like below: 1 variable(userid) with 4 records. userid user1 user2 user3 user4 3.With %mduextr(libref=current); I've extract the current Metadata. 4. Got list of abcd group users' keyid from current.logins table. Updated Ex: abcd dataset looks like below: userid keyid user1 AS875.4728DS user2 user3 AD484.6468RT user4 AS784.7854GR Meaning: user1, user3, and user4 are SAS Users/ have Identities in Metadata. And are the only ones who needs to be part of SAS Meta group (we will get to that in following step). 5. To align with current.grpmems table: Added variable grpkeyid (with gepkeyid value of a group that these users need to be part of) (gepkeyid value of a group is read from current.group_info table (id variable in current.group_info table is = grpkeyid in current.grpmems table)), dropped records with missing keyid values and renamed keyid to memkeyid. Updated Ex: abcd dataset looks like below: grpkeyid memkeyid A5246F67.A20000SP AS875.4728DS A5246F67.A20000SP AD484.6468RT A5246F67.A20000SP AS784.7854GR 6. Ran abcd dataset against current.grpmems table to filter records that are not already part of current.grpmems table. Assuming row1 and row3 already exist in current.grpmems table: Updated Ex: abcd dataset looks like below: grpkeyid memkeyid A5246F67.A20000SP AD484.6468RT 7. Exported abcd dataset to a txt file: adbc.txt below: A5648E54.A50000SP AD484.6468RT Steps until here are completed, Now, we'd like add this above record to grpmems table so that user becomes part of SAS Meta Group. I see taking different paths leading into different errors. Can you let me know how I can proceed here to have these changes made? Thank you! Regards, Vishnu Perni
... View more
