Work.person ( keep=keyid name DisplayName title description in=user ) * Combine data from multiple tables */ data tadata_users ( drop=keyid ) * Extract user information from the SAS metadata */ * Connect to the SAS metadata server */ options metaserver = "." Having the above tables at your fingertips, you can easily combine them in any way you need to generate a report you want. When invoked, it extracts SAS user identity information from the SAS metadata and creates several canonical tables: This macro is documented in the SAS Intelligence Platform: Security Administration Guide and it is one of the several User Import Macros that you get with SAS Business Intelligence or SAS Visual Analytics installation. Luckily, SAS provides you with a little-known, but well-documented macro that makes such SAS users reporting a snap. Suppose, you have multiple SAS users defined in the SAS Management Console as in the following example:Īfter adding a couple dozen (or hundred) users to SAS Metadata using the User Manager plug-in of the SAS Management Console you will start dreaming of some “push-a-button” report that will show a listing of all your SAS users with all the relevant information (name, title, description, e-mail, groups, user id, etc.) in a plain view. If you are a SAS Administrator who is tasked with managing SAS users including adding and removing SAS users in the SAS Management Console, assigning (or re-assigning) them to Groups and Roles, maintaining their General information and user Accounts, then you know that when number of users grow, at some point things can get messy. I also recommend: SAS administrators tip: Automatically deleting old SAS logs
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |