topic Re: Is it possible to rename the metadata definition of objects in SAS Management Console? in SAS Enterprise Guide

Is it possible to rename the metadata definition of objects in SAS Management Console?

THALLA_REDDY — Mon, 28 Feb 2022 19:01:52 GMT

Hi there,

we have some user groups defined in the metadata library using the SMC 9.4_M7 version. Now after creating these initial names we came to know that there are some special characters in the names like ;'&/- etc., When checked some solutions in SAS Community to rename them got some inputs from this thread => https://communities.sas.com/t5/Administration-and-Deployment/Is-it-possible-to-rename-the-metadata-defintion-of-objects-in/td-p/443705. After trying from the below code we are able to rename few USER Groups where we don't have apostrophe but if we have any quote (single quote or apostrophe) in the name then getting the error.

Example of my USER Group name: 01234-ABC'd Inc

Now we want this User Group to be renamed as: 01234-ABCd Inc

Below is the code we tried:

data changenames; length oldname newname $256.; infile datalines dsd; input oldname $ newname $; datalines; 01234-ABC'd Inc, ABCd Inc ; run; data identitygroups(keep=uri oldname newname rc); length uri $256; nobj=1; n=1; set changenames; do while(nobj >= 0); nobj=metadata_getnobj(cats("omsobj:IdentityGroup?@Name='",oldname,"'"),n,uri); rc=metadata_setattr(uri,"Name",newname); n=n+1; end; run;

Any help on this requirement is highly appreciated.

thanks in advance.

Re: Is it possible to rename the metadata definition of objects in SAS Management Console?

SASKiwi — Mon, 28 Feb 2022 19:35:08 GMT

Is deleting and recreating them possible? Have you tried this in SMC?

It is probably worth checking with SAS Tech Support on this.

Re: Is it possible to rename the metadata definition of objects in SAS Management Console?

Sajid01 — Wed, 02 Mar 2022 01:32:06 GMT

Under similar scenario, i would create new group, backup the metadata and then delete the old group.
Make sure you have all the users in the group as well as the access controls replicated.

Re: Is it possible to rename the metadata definition of objects in SAS Management Console?

THALLA_REDDY — Fri, 04 Mar 2022 06:45:39 GMT

Yes, I have tried in SMC but metadata is not getting reflected eventhough I am seeing the name in SMC is changed. It's strange for me.

Re: Is it possible to rename the metadata definition of objects in SAS Management Console?

THALLA_REDDY — Fri, 04 Mar 2022 06:46:36 GMT

thanks, I will check and try based on the possibilities