topic Getting an error while adding / removing the access to a user from a user group in SAS Enterprise Guide

Getting an error while adding / removing the access to a user from a user group

THALLA_REDDY — Fri, 30 Jul 2021 17:41:42 GMT

Hi Team,

I am using the below PROC Meta data code for adding / removing the access to user group for a user(colleague), but getting an error due to a special character in the group name.

Code used :

proc metadata in=
"<UpdateMetadata>
<Metadata>
<Person Id=%str(%')&PersonId%str(%')>
<IdentityGroups Function=&FUNC>
<IdentityGroup ObjRef=%str(%')&GroupId%str(%') Name=%str(%')&Group%str(%')/>
</IdentityGroups>
</Person>
</Metadata>
<ReposId>$METAREPOSITORY</ReposId>
<ns>SAS</ns>
<flags>268435456</flags>
<Options/>
</UpdateMetadata>";
run;

Error Snapshot:

Can anyone help me with a solution to fix this ?

thanks in advance

thalla

Re: Getting an error while adding / removing the access to a user from a user group

SASKiwi — Mon, 02 Aug 2021 04:15:57 GMT

Looks like one of your user group names includes a quote. You should fix this at source to not contain quotes. Defining user groups containing quotes is just bad practice.

Re: Getting an error while adding / removing the access to a user from a user group

jimbarbour — Wed, 04 Aug 2021 18:00:48 GMT

As @SASKiwi says, I think you're only going to get trouble if you allow single quotes in the Group name.

However, maybe as a temporary work around you could try coding a %BQUOTE around the Group name. I still think you may have trouble though down the road. Use at you own risk.

	"<UpdateMetadata>
	<Metadata>
	<Person Id=%str(%')&PersonId%str(%')>
	<IdentityGroups Function=&FUNC>
	<IdentityGroup ObjRef=%str(%')&GroupId%str(%') Name=%str(%')%BQUOTE(&Group)%str(%')/>
	</IdentityGroups>
	</Person>
	</Metadata>
	<ReposId>$METAREPOSITORY</ReposId>
	<ns>SAS</ns>
	<flags>268435456</flags>
	<Options/>
	</UpdateMetadata>";

Jim