topic need to Add or update the email addresses of the users on Metadata in Administration and Deployment

need to Add or update the email addresses of the users on Metadata

Santt0sh — Thu, 13 Dec 2018 20:35:51 GMT

Hi All,

I need to Add or update email addresses for users on Metadata, I have more than 100 emails to be updated and this request comes

frequently and i spend a lot of time updating the Email type and the Email addresses.

Could you please suggest, how this can be done by using a Macro or a program?

I have used proc metadata to register a table.

Thank you!!!

Regards S.....

Re: need to Add or update the email addresses of the users on Metadata

Kurt_Bremser — Fri, 14 Dec 2018 07:06:03 GMT

Look at the two programs importad.sas and importpw.sas in SASHOME/SASFoundation/9.4/samples/base.

There you can see how external data is prepared for syncing with the metadata. Use the "extract" part to create the normalized database of users, and one of the tables will contain the emails as currently stored in metadata. Put your new emails in there, and run the sync off that.