topic Re: Query Active Directory with SAS and produce data set? in SAS Programming

Query Active Directory with SAS and produce data set?

kjohnsonm — Fri, 09 Mar 2018 18:13:48 GMT

Is it possible to query my local Active Directory with SAS returning data set?

In this case I have a set of 2700 network Id (NID), that might be former/current/locked down status, but I want to connect to my AD and return any information like user name, dept, status, last login date.

I guess what I am asking is can I create a libname command or something similar given I have access to AD? TIA. -KJ

PS I know there are some PowerShell tools out there but I am already preprocessing my data to get the NID, and some security rights fields for the first phase of this project I thought I would check to see if I could get it all done in SAS and not have to use other tools.

Re: Query Active Directory with SAS and produce data set?

SuryaKiran — Fri, 09 Mar 2018 20:59:11 GMT

Are you trying to access a network drive from SAS? You can map a network drive in SAS using SAS Management Console. This is an Admin task.

Re: Query Active Directory with SAS and produce data set?

kjohnsonm — Fri, 09 Mar 2018 21:14:59 GMT

SuryaKiran,

No; I already do that in some cases. (meaning I do not use it offten but do use that feature with network file shares)

No I literally have a list of 2700 Network ids with access to a server I suport and I need to cross check if the users are still active AD users with rights or not.

So I have read my data with NID and group relationships parsed it as I need it, and I want to read from an Active Directory server like it was a libname sucking in all the info about the given 2700 users with a left join (the bonus info would to trap any nid not in the AD set and write indicator field).

My AD servers could have a over million of NID records so I really don't want a data dump of all of them if I do not have too...

but if i do, such is life. 😎 -Kj

Re: Query Active Directory with SAS and produce data set?

Patrick — Fri, 09 Mar 2018 22:07:59 GMT

@kjohnsonm

importad.sas could give you a starting point to get to the code you want to.

http://documentation.sas.com/?docsetId=bisecag&docsetTarget=p1g7fdz3po09len1ev2f3qpo89df.htm&docsetVersion=9.4&locale=en

http://documentation.sas.com/?docsetId=bisecag&docsetTarget=n16wd5khdis6qon1ac6rbmv79wyd.htm&docsetVersion=9.4&locale=en

Re: Query Active Directory with SAS and produce data set?

kjohnsonm — Fri, 09 Mar 2018 22:35:31 GMT

Patrick,
That second doc seems perfect starting point. that is nice, thank you for your time. I do not think I have ever been directed to this dir as a shared local repository for sample code. -KJ