BookmarkSubscribeRSS Feed
Quartz | Level 8

Hi Experts,


I have users (i.e. Managers & Employees) in the data. Need to apply row level security like a Manager should see the data for employees who falls under him/her and an Employee can see only his/her data.


This can be done using process described in below link:


But here, i need to make this part automated. Suppose, an Employee Moves from one manager to another manager. And there are 1000s of employees so following the above link won't be a good way.


I have another table apart from main data table which has Employee Manager relations and gets updated daily basis.



Rhodochrosite | Level 12


There will be 2 types of flow, one for defining the actual row-level-where-statement and one for the group-user-assignment.


The first one can use the "SUB::SAS....." user-driven-identities to subset data depending on user and the groups he/she belongs to.

The second one puts the users in the groups and can be achieved by using canoncical tables and SAS macros:


I have created groups which names are the same as the divisions in my company and then the where-statements use this information to subset the data, like: "division in (SUB::SAS.Identitygroups)"


Hope this can guide you in the right direction 🙂





Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2 in conversation