Blogs

Blogs

Adding groups of users into metadata programmatically

2
By

Interested in adding a group of users into Metadata w/o Management Console?
Included is an example of how to add one user:

PROC METADATA SERVER="my_sas_srv_name" PORT=8561 USERID="sasadm@saspw" PASSWORD="xxxxxxxx" PROTOCOL=BRIDGE
in="<AddMetadata>
<Metadata>
<Person Desc='Manager of clinical studies.' Name='Joe E. Doe' Title='Manager of Clinical Studies'>
</Person>
</Metadata>
<Reposid>A0000001.A5VLFKMC</Reposid>
<NS>SAS</NS>
<Flags>268435456</Flags>
<Options/>
</AddMetadata>";
run;

In order to include multiple users, I would simply set up a data set containing all the elements for the "<Person " tag (this could be a proc import from an excel spreadsheet) and pass these into the above proc metadata step using call execute statements. A good resource for accomplishing this is located in the SAS User Papers - http://www2.sas.com/proceedings/sugi30/027-30.pdf.

Tags business intelligence Management Console Metadata
Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

2 Comments

  1. Neelakant Yerra on

    You just showed how to add few attribute. but if we need to add the same user to a group which is existing in metadata and also needs to create login ID's for the user in the metadata what attributes do we need to add to the current XML code.

    Your response is greatly appreciated.

    Thanks,
    Neelakant Yerra

  2. Paul Van Mol on

    When loading users and groups in the SAS Metadata Server, there are a few standard macros that are foreseen in the security administration documentation.

    These routines have some benefits compared to the proc metadata:
    1. to import users/groups from Active Directory
    2. to synchronize users and groups between your Active Directory and SAS Metadata Server.

Back to Top