DATA Step, Macro, Functions and more

Get the users email based on their username

Reply
Contributor
Posts: 65

Get the users email based on their username

Hi, 

I want to identify the mail ID from windows username in SAS. In .NET I have the code for same as below:-

System.DirectoryServices.AccountManagement.UserPrincipal.Current.EmailAddress()

 

But I am not able to find any solution in SAS. Please help!

Thanks.

Super User
Posts: 6,938

Re: Get the users email based on their username

I'd suggest to write a little .NET program that makes that method/function call and writes the result to standard output.

Then call that program from SAS with

filename oscmd pipe "your_net_program";
data _null_;
infile oscmd;
input;
call symput('current_email',_infile_);
run;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Super User
Posts: 7,401

Re: Get the users email based on their username

Assuming you have priviledge to access Active Directory properties then DSGET/DSQUERY:

https://technet.microsoft.com/en-us/library/cc732535(v=ws.11).aspx

 

Some examples:

https://social.technet.microsoft.com/Forums/windowsserver/en-US/c5f5e0b6-7fe3-4c80-8d9b-972252e9552f...

http://serverfault.com/questions/27223/command-line-active-directory-query-email-address-for-usernam...

 

However I would point out that SAS is built to do analysis and processing of data, not for doing administrative tasks on your operating systems, so it sounds like your doing something wrong.  I presume if you are after email then your sending something to someone?  If so then there are far better methods out there - shared network area, sharepoint, report publishing platforms etc.  Sending things via email can be unsecure, and there are limits on what you can send.

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 182 views
  • 0 likes
  • 3 in conversation