List all libraries and Groups given access to that library

[Sanjay_M]

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.

[LinusH]

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.

[rajdeep]

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.