Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is stored in SAS Metadata to then synchronize the two.
Try this code in BASE SAS (after updating the options statement). The program takes a few moments to run, but it returns a set of metadata extract tables.
options metaserver=servername metauser="username" metapass="userpassword"; %mduextr(libref=work)
In all, there are over 20 resulting tables now available within your work library.
Here are some thoughts that I had:
- Looking at the list of tables, Grpmems (which only contains the unique group key and the unique person key) I could join with Group_info and Person_info tables to get a complete picture of who is a member of what group.
- Using the Email table, I could quickly grab a list of users email addresses to send email messages (even using BASE SAS).
- The location table (which contains a person's address) could be leveraged as a permanent data table (updated daily/weekly) to auto populate custom SAS Stored Process forms.
And remember these are just ideas of the one user synchronization macro mentioned here (%MDUEXTR)! There are five more. What can you dream up?