Hi!
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: https://documentation.sas.com/?docsetId=bisecag&docsetTarget=p1o31lg0trorn8n1rketxxe1jbr1.htm&docsetVersion=9.4&locale=sv
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 🙂
//Fredrik
... View more