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

[Santt0sh]

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.....

[Kurt_Bremser · Accepted solution]

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.