BookmarkSubscribeRSS Feed
Pyrite | Level 9

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,





Opal | Level 21

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


Meteorite | Level 14

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,


//Contact me to learn how Metacoda software can help keep your SAS platform secure -
Tourmaline | Level 20

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 4 in conversation