topic Re: Extract groups, roles and their descriptions in SAS Programming

Extract groups, roles and their descriptions

Armand0 — Thu, 12 Aug 2021 23:24:59 GMT

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.

Re: Extract groups, roles and their descriptions

SASKiwi — Fri, 13 Aug 2021 00:32:31 GMT

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.

Re: Extract groups, roles and their descriptions

Armand0 — Fri, 13 Aug 2021 00:58:09 GMT

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

Re: Extract groups, roles and their descriptions

ChrisNZ — Fri, 13 Aug 2021 01:54:38 GMT

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

Ask more questions if you become stuck.

Re: Extract groups, roles and their descriptions

andreas_lds — Fri, 13 Aug 2021 04:41:51 GMT

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