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.
With METABROWSE and other metadata calls no longer needed, what use cases can you think up with all of this data so quickly available?
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?
3 Comments
Check out this exchange between Paul Homes and Don Henderson for another use of the MDUEXTR macro. https://communities.sas.com/thread/36595
Thanks Angela!
Munching metadata is magnificent. I have Frank DiIorio's excellent summary of dictionary tables taped next to my monitor (http://www.codecraftersinc.com/pdf/DictionaryTablesRefCard.pdf). Great to have access to this server metadata as well!
--Q.
Excellent macros to use!
More uses:
- Synchronize email addresses to send Alerts via BI Dashboard (make business users more proactive!)
- Use the macros to interactively import select users into SAS metadata using a Stored Process as I've outlined in my paper from SASGF12 (http://support.sas.com/resources/papers/proceedings12/377-2012.pdf)