Architecting, installing and maintaining your SAS environment

SAS metadata - list users/roles and groups

Regular Contributor
Posts: 241

SAS metadata - list users/roles and groups

Hello all,


I managed to create a list of which users are in which groups/have which roles


I want to make a list now of which roles are in which groups. And if possible, which groups are in another group.


Thanks in advance,





Super User
Posts: 3,555

Re: SAS metadata - list users/roles and groups

You could save yourself some considerable effort and check out third-party tools:


Trusted Advisor
Posts: 1,365

Re: SAS metadata - list users/roles and groups

Thanks @SASKiwi for mentioning the Metacoda tools.


@Filipvdr if you are after nesting information about Users, Groups and Roles, the Metacoda Security Plug-ins software provide this with the User Reviewer, Group Reviewer and Role Reviewer Plug-ins. These reviewers also have reporting and exporting facilities. @PaulHomes demonstrated these reviewers at a recent SAS User Group for Administrators (SUGA) webinar which you can see the ondemand webinar, slides and Q&A at


Please feel free to contact us if you have any questions and would like a free 30 day evaluation.


Kind Regards,


Super User
Posts: 5,694

Re: SAS metadata - list users/roles and groups

Posted in reply to MichelleHomes

An alternative to the assumed great tools from Metacoda, a programmatic approach could include use of the %mdu macro family, which would fill this (and other related information) to "cannonical tables":


Also, there is a security reporting macro documented in a parallel appendix.

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 4 in conversation