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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

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