I support the higher education institute as an administrator. We have about 400 plus SAS users who have been granted access to SAS and pull their departmental data/Student information that they are interested in. We are in the process of evaluating who all are genuinely needing access from the existing system and rest can be revoked. So I need to find out all the users who have not logged in for the past 3 months or so that will help me to have a yearly purging of users process in place.
Appreciate any lead on this.
Thank you datasp.
I can obtain the list of all SAS users in a spreadsheet with the column names like shown below:
App_UserId ( Employee Id@eid ex. A1234555@eid)
Comp_EID (company domain id with format First letter of the first name and employee ID. ex A1234555)
Person_Id (Employee ID, ex. 1234555)
Below is the purge program I use to remove the terminated users.
We receive all terminated users list from the tool collaborated with HR information daily. I modify the filename with the date and update the date macro in the below sas program to reflect the file that is going to be imported.
If there is any terminated users in the current user list then I go and delete the user from SAS management console manually.
set DataReq.APPS_Users ;
/*Change the date daily*/
%LET date = 072619;
INFILE "D:\PROJECTS\APPS\Terminated users daily log\Raw Data\A70_TERM_USERS_&date..xls" DLM='09'x DSD MISSOVER LRECL=32767 firstobs=4;
Proc sort data=APPS_Current_user;
Proc Sort data=A70_term_user;
merge APPS_Current_user (in=ina) A70_term_user (in=inb);
if ina and inb;
Proc print data=APPS_Terminate_User_list;
title "APPS Terminate users list";
we need EmployeeID and last LoginDate only. Using the current Date you can find out the time interval of interest. That will give the list of users who have not logged for the past n-months. It is a simple program only.
I have written code to retrieve login events from the metadata server logs, see here:
Also consider using the Environment Manager, but I have no experience with that.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.