10/4/2023 0 Comments Sas metadata structurePERSON_INFO table PROC PRINT DATA=WORK.PERSON_INFO This lists the basic user info that you see in the “General” tab of a user’s Properties in SAS Management Console, as well as some Metadata keys and object IDs. PERSON table PROC PRINT DATA=WORK.PERSON The more useful details about user logins, such as the name of the Authentication Domain to which they below (the LOGINS table only provides the Authentication Domain Object ID, but not the useable name).įor example, should you wish to extract all usernames with a “DefaultAuth” entry you could query the table like this: PROC SQL LOGINS_INFO table PROC PRINT DATA=WORK.LOGINS_INFO which Authentication Domains exist, but not the accounts associated to individual user accounts). Lists all of the configured Authentication Domains (i.e. Once you have run the macro above you can interogate your WORK library with PROC DATASETS to list all tables that have been extracted: PROC DATASETS LIBRARY=WORK Table Examples AUTHDOMAIN table PROC PRINT DATA=WORK.AUTHDOMAIN %MDUEXTR (LIBREF=WORK) Metadata Table Details This example will extract the Metadata identity tables to your session WORK library for temporary access within that session. Usage Syntax %MDUEXTR (LIBREF=SAS-library) Example The “%MDUEXTR” macro is available in all SAS 9.x installations, and is available to extract SAS user identity information from SAS Metadata into a target SAS Library. While in most cases you can use tools like SAS Management Console to look into SAS Metadata, sometimes it is useful to access the contents of SAS (9.x) Metadata programatically.įor example you may wish to extract a list of usernames, or join a table to usernames to extract user details such as Display Name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |