Dynamic SAS Stored Process Based Web Application

Question

<style type="text/css">
.tg  {border-collapse:collapse;border-spacing:0;}
.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;
  overflow:hidden;padding:10px 5px;word-break:normal;}
.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;
  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}
.tg .tg-9wq8{border-color:inherit;text-align:center;vertical-align:middle}
.tg .tg-za14{border-color:inherit;text-align:left;vertical-align:bottom}
.tg .tg-7zrl{text-align:left;vertical-align:bottom}
.tg .tg-nrix{text-align:center;vertical-align:middle}
</style>
<table class="tg">
<thead>
  <tr>
    <th class="tg-za14">Manager</th>
    <th class="tg-za14">Sub Manager</th>
    <th class="tg-za14">Staff</th>
    <th class="tg-7zrl">Response</th>
  </tr>
</thead>
<tbody>
  <tr>
    <td class="tg-9wq8" rowspan="5">A</td>
    <td class="tg-9wq8" rowspan="3">A1</td>
    <td class="tg-za14">A1A</td>
    <td class="tg-7zrl">Yes</td>
  </tr>
  <tr>
    <td class="tg-za14">A1B</td>
    <td class="tg-7zrl">No</td>
  </tr>
  <tr>
    <td class="tg-za14">A1C</td>
    <td class="tg-7zrl">Yes</td>
  </tr>
  <tr>
    <td class="tg-9wq8" rowspan="2">A2</td>
    <td class="tg-za14">A2A</td>
    <td class="tg-7zrl">Yes</td>
  </tr>
  <tr>
    <td class="tg-za14">A2B</td>
    <td class="tg-7zrl">No</td>
  </tr>
  <tr>
    <td class="tg-nrix" rowspan="9">B</td>
    <td class="tg-nrix" rowspan="4">B1</td>
    <td class="tg-7zrl">B1A</td>
    <td class="tg-7zrl">No</td>
  </tr>
  <tr>
    <td class="tg-7zrl">B2B</td>
    <td class="tg-7zrl">No</td>
  </tr>
  <tr>
    <td class="tg-7zrl">B2C</td>
    <td class="tg-7zrl">Yes</td>
  </tr>
  <tr>
    <td class="tg-7zrl">B2D</td>
    <td class="tg-7zrl">No</td>
  </tr>
  <tr>
    <td class="tg-nrix" rowspan="2">B2</td>
    <td class="tg-7zrl">B2A</td>
    <td class="tg-7zrl">Yes</td>
  </tr>
  <tr>
    <td class="tg-7zrl">B2B</td>
    <td class="tg-7zrl">No</td>
  </tr>
  <tr>
    <td class="tg-nrix" rowspan="3">B3</td>
    <td class="tg-7zrl">B3A</td>
    <td class="tg-7zrl">No</td>
  </tr>
  <tr>
    <td class="tg-7zrl">B3B</td>
    <td class="tg-7zrl">Yes</td>
  </tr>
  <tr>
    <td class="tg-7zrl">B3C</td>
    <td class="tg-7zrl">Yes</td>
  </tr>
</tbody>
</table>

I want to use SAS Stored process based web application with dynamic functionality.

Suppose I have list of managers, sub managers and staff.

I want manager to provide a response at staff level which I want to store in some database.

I want to check feasibility on Stored process and stored process based web application.

Requirement is that only manager should fill the response. And manager can have any number of sub managers within him/her and any number of staff within sub manager.

Code attached to see sample hierarchy.

Answer 1

Our product (Data Controller for SAS) would actually do this for you, out of the box - https://datacontroller.io

Just set the row level permissions accordingly: https://docs.datacontroller.io/row-level-security/