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.
The macro %mduextr exports all users and groups to datasets, the dataset group_info contains all groups and roles including their description.
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.
thanks for your comment, Will you know the name of the macros that you mention?
You could start here: https://support.sas.com/resources/papers/proceedings17/1275-2017.pdf
Ask more questions if you become stuck.
The macro %mduextr exports all users and groups to datasets, the dataset group_info contains all groups and roles including their description.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.