topic List all libraries and Groups given access to that library in SAS Programming

List all libraries and Groups given access to that library

Sanjay_M — Thu, 23 Nov 2017 11:21:16 GMT

Hi, I want to write code to get a list of all libraries and also get the group names for each library that have been given access.

Re: List all libraries and Groups given access to that library

LinusH — Thu, 23 Nov 2017 11:37:25 GMT

You are talking about libraries and users that are registered in metadata, right?

You could get some information out of the canonical tables (managed by the %mdu family macros).

Another option is to use Metacodas plugin for SMC, it will probably give you answer like this.

The last resort (IMO) is start programming against the metadata API.

Re: List all libraries and Groups given access to that library

rajdeep — Tue, 10 Dec 2019 17:33:19 GMT

Hi LinusH,

I have a secure library which I had created using the below code and it's successfully creating the secure library in SMC.

proc authlib lib=loc;
create seclib="&seclib."
securedfolder="PCB1"
pw="test"
require_encryption=yes
encrypt=aes
encryptkey="test" ;
run;
quit;

Now I have two sas datasets under the secure library, I want to add a group for those two sas datasets through program. For that I had researched and I ran %mduextr macro, which gives the Metadata Info in Canonical tables forms.

I just want to know how to add a customized Group for those data-sets through code. Can you please take out few minutes of your time and help me out ?

Thanks in Advance.