Extract groups, roles and their descriptions

[Armand0]

Hi,

For internal audit issues they are asking me for a list of groups and roles with their descriptions as they come in the SAS Management Console I don't know much about SAS code. Is there a way to get this with code?

I would greatly appreciate your help.

[SASKiwi]

Do you synch your SAS metadata user definitions from external security sources such as Active Directory? If the answer is yes then you can query Active Directory SAS AD group data just using SQL. If no then you will need to query the SAS metadata repository for which there are some standard macros that SAS provides.

[Armand0]

thanks for your comment, Will you know the name of the macros that you mention?

[ChrisNZ]

You could start here: https://support.sas.com/resources/papers/proceedings17/1275-2017.pdf

Ask more questions if you become stuck.

[andreas_lds · Accepted solution]

The macro %mduextr exports all users and groups to datasets, the dataset group_info contains all groups and roles including their description.