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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: