BookmarkSubscribeRSS Feed
Akshay1005
Fluorite | Level 6

Hello,

 

Is there any SAS code that can helps us retrieve email address of all users declared in the metadata?

Dunno by accessing the PERSON, EMAIl, etc... table

 

Than]king you in advance for help.

 

Regards,

Akshay

 

 

3 REPLIES 3
gwootton
SAS Super FREQ
Does this program give you what you need?

https://github.com/greg-wootton/sas-programs/blob/main/Metadata%20Management/get_emails.sas
--
Greg Wootton | Principal Systems Technical Support Engineer
jklaverstijn
Rhodochrosite | Level 12

Any time I need user related metadata I normally take the quick and easy way and use the SAS supplied macro %MDUEXTR. It probably gives you more than you need but it saves an awful lot of coding. Do it as a first step in a EG project and the rest will be clever joining, filtering and reporting on the resulting tables. In code:

%MDUEXTR(LIBREF=WORK);

 

One of the resulting tables is EMAIL (all have obvious names) that can be joined with others, like PERSONS, for additional context.

 

Hope this helps,

- Jan.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 560 views
  • 0 likes
  • 4 in conversation